mysql NULL function


  Translation results:

UK [nʌl] US [nʌl]

adj.<Art>zero value; equal to zero; (agreement) has no legal effect; invalid

mysql NULL functionsyntax

Function:If a column in the table is optional, then we can insert new records or update existing records without adding a value to the column. This means that the field will be saved with a NULL value.

Note: NULL values ​​are handled differently than other values. NULL serves as a placeholder for unknown or inapplicable values.

Comments: NULL and 0 cannot be compared; they are not equivalent.

mysql NULL functionexample

//选取在 "Address" 列中带有 NULL 值的记录
SELECT LastName,FirstName,Address FROM Persons WHERE Address IS NULL;
//选取在 "Address" 列中不带有 NULL 值的记录
SELECT LastName,FirstName,Address FROM Persons WHERE Address IS NOT NULL;

Popular Recommendations

Home

Videos

Q&A