NULL VALUES



MySQL - Null Values


MySQL NULL Condition is used to test for a NULL value in a SELECT, INSERT, UPDATE, or DELETE statement.


SYNTAX FOR IS NULL :

SELECT column_names
FROM table_name
WHERE column_name IS NULL;

EXAMPLE :


SELECT StudentName, ParentName, Address FROM studentrecord
WHERE Address IS NULL;
StudentNameParentNameAddress
---

SYNTAX FOR IS NOT NULL :

SELECT column_names
FROM table_name
WHERE column_name IS NOT NULL;

EXAMPLE :

SELECT StudentName, ParentName, Address FROM Infostudents
WHERE Address IS NOT NULL;
StudentNameParentNameAddress
AnasyaJagannathBanjara Hills
ShivanatiniPraveenHayath Nagar


MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials


how to use range in golang

how to use range in golang

posted on 2022-05-03 08:28:11 - Go lang Tutorials


find variable type in golang

find variable type in golang

posted on 2022-05-03 05:24:55 - Go lang Tutorials


for loops in golang

for loops in golang

posted on 2022-05-03 04:27:40 - Go lang Tutorials