MySQL allows you to create table with SET NULL option. Doing so will delete or update the row from the parent table, and set the foreign key column or columns in the child table to NULL.

Using the default value as NOT NULL, while creating a MySQL table, it can be enforced that a column in a table is not allowed to store NULL values.

In this page we have discussed how to test if a date value is not NULL.

MySQL is null operator will test a whether a value is NULL. If satisfied, then returns 1 otherwise returns 0.

Tutorial or reference of mysql in() function, covering description, syntax, example code, example of using php and explanation by w3resource.com

MySQL null safe equal to operator performs an equality comparison like the = operator, but returns 1 rather than NULL if both operands are NULL, and 0 rather than NULL if one operand is NULL.

In this page we have discussed how to use NULL, IS NULL an IS NOT NULL with SELECT statement.

In this page we have discussed how to insert NULL values for into one or more columns using MySQL INSERT INTO statement