Php-mysql Course

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

What attribute makes an option from <select> selected?
checked="checked" selected="selected" disabled="disabled"
<select name="a_name">
 <option value="val1">Option 1</option>
 <option value="val2" selected="selected">Option 2</option>
What CSS value allows to create color gradients for background?
contain repeat-x linear-gradient
#id {
  background: linear-gradient(top left, #1f1, #fff, #11f);
What statement creates an array in JavaScript?
[] {} new Object()
var arr = [1, "", ""];
Indicate the PHP function used to redirect to other page.
function() header() switch()
Insert, Select and Update NULL value in MySQL

Last accessed pages

  1. PHP Script Website Mini-Traffic (6006)
  2. Follow the mouse cursor with a DIV inside a Parent (7074)
  3. PHP Unzipper - Extract Zip, Rar Archives (20161)
  4. PHP PDO - Select query, fetch (27646)
  5. Add text between two DIV tags (2964)

Popular pages this month

  1. PHP Unzipper - Extract Zip, Rar Archives (42)
  2. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (29)
  3. JavaScript Course - Free lessons (28)
  4. HTML Course - Free Lessons (23)
  5. SHA1 Encrypt data in JavaScript (19)