In this tutorial you can learn how to work with NULL in MySQL tables: Insert, Update, and Select columns with NULL value.

Add column with NULL value

To insert into a MySQL table rows with columns having NULL, add the NULL value without quotes.
$sql = "INSERT INTO `table_name`
 (`column1`, `column2`, `column3`)
 ('val1', NULL, 'val3')";

Or, if the NULL value is stored into a variable, add "NULL" as a string to that variable, then write the variable into the SQL query, without quotes.
$nul = 'NULL';
$sql = "INSERT INTO `table_name`
 (`column1`, `column2`, `column3`)
 ('val1', $nul, 'val3')";

- If you create the $nul value like this:   $nul = NULL; , the SQL query will contain nothing in the place where this variable is added. Will result:
INSERT INTO `table_name` (`column1`, `column2`, `column3`) VALUES ('val1', , 'val3')

- If you want to insert the string "NULL", add it within quotes:
$sql = "INSERT INTO `table_name`
 (`column1`, `column2`, `column3`)
 ('val1', 'NULL', 'val3')";

UPDATE with NULL value

The same works with UPDATE.
$sql = "UPDATE `table_name` SET `column1`='val1', `column2`=NULL, WHERE `column3`='val3'";
$nul = 'NULL';
$sql = "UPDATE `table_name` SET `column1`='val1', `column2`=$nul, WHERE `column3`='val3'";

SELECT fields with NULL value

To select rows in a MySQL table according to columns with NULL value, use IS NULL.
$sql = "SELECT * FROM `table_name` WHERE `column` IS NULL";

If you want to Not return the rows with a specific NULL field, use IS NOT NULL.
$sql = "SELECT * FROM `table_name` WHERE `column` IS NOT NULL";

Daily Test with Code Example

Which attribute is used in <a> tag for the address of the link?
src href rel
<a href="" title=""></a>
Which CSS property sets the type of the text font?
font-family text-decoration font-size
h2 {
What instruction selects all the <div> tags with class="cls"?
querySelector("div.cls") getElementsByTagName("div") querySelectorAll("div.cls")
var elm_list = document.querySelectorAll("div.cls");
var nr_elms = elm_list.length;       // number of selected items
Indicate the function that can be used to get the sum of values in an array.
array_sum() array_diff() array_shift()
$arr = array(1, 2, 3, 4);
$arr_sum = array_sum($arr);
echo $arr_sum;       // 10
Insert, Select and Update NULL value in MySQL

Last accessed pages

  1. New Form elements and attributes in HTML5 (1613)
  2. Courses Web: PHP-MySQL JavaScript Ajax HTML CSS Flash-AS3 (11067)
  3. Remove / Get duplicate array values - Reset array keys in PHP (2052)
  4. PHP PDO - exec (INSERT, UPDATE, DELETE) MySQL (9477)
  5. Star shapes with CSS (1067)

Top accessed pages

  1. PHP-MySQL free course, online tutorials PHP MySQL code (11451)
  2. Courses Web: PHP-MySQL JavaScript Ajax HTML CSS Flash-AS3 (11067)
  3. Get Attribute (ID, Class, Name, Title, Src) with jQuery (10667)
  4. PHP Chat Script (9829)
  5. PHP PDO - exec (INSERT, UPDATE, DELETE) MySQL (9477)