Is it necessary to add DEFAULT NULL in MySQL?

No, it isn’t necessary because without adding DEFAULT NULL, it gives NULL value. For example, let’s say you haven’t added DEFAULT NULL and inserted a record with no value, then the result would display the NULL value as the inserted value.

Let us first create a table −

mysql> create table DemoTable
(
   FirstName varchar(100)
);
Query OK, 0 rows affected (0.57 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable values('Chris');
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values();
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable values();
Query OK, 1 row affected (0.21 sec)
mysql> insert into DemoTable values('David');
Query OK, 1 row affected (0.12 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable;

This will produce the following output −

+-----------+
| FirstName |
+-----------+
| Chris     |
| NULL      |
| NULL      |
| David     |
+-----------+
4 rows in set (0.00 sec)

AmitDiwan

Updated on 26-Sep-2019 08:19:44

• Related Questions & Answers
• Is it necessary to have a responsive website?
• Insert default into not null column if value is null in MySQL?
• Why is it necessary to declare NOT FOUND handler while using MySQL cursor?
• How to set default value to NULL in MySQL?
• Why is it necessary to have a girl or boyfriend in life?
• Is it necessary to select the database each time we begin a MySQL session? How can it be done?
• Adding a column whose value is not null by default in MySQL?
• How to check whether column value is NULL or having DEFAULT value in MySQL?
• What is mundan ceremony or mundan sanskar and why is it necessary?
• How to add a NOT NULL column in MySQL?
• Treat a MySQL column field as NULL if it is blank?
• How to add not null constraint to existing column in MySQL?
• Working with NULL and IS NOT NULL in MySQL
• Is it impossible to add a column in MySQL specifically before another column?
• How to update a field with a particular value if it is null in MySQL?