DEFAULT NULL column when column created with NOT NULL

Question

I created a table in mysql. Every column in my table I created with NOT NULL. What does the NULL value in my DEFAULT column mean? I never plan to have a NULL value in those columns.

+------------+--------------+------+-----+-------------------+-------+
| Field      | Type         | Null | Key | Default           | Extra |
+------------+--------------+------+-----+-------------------+-------+
| user_id    | binary(16)   | NO   | PRI |                   |       |
| first_name | varchar(255) | NO   |     | NULL              |       |
| last_name  | varchar(255) | NO   |     | NULL              |       |
| email      | varchar(255) | NO   | UNI | NULL              |       |
| digest     | binary(40)   | NO   |     | NULL              |       |
| join_ts    | timestamp    | NO   |     | CURRENT_TIMESTAMP |       |
+------------+--------------+------+-----+-------------------+-------+

Nir Levy · Accepted Answer · 2015-09-27 23:19:19Z

1

This means you don't have a default value for these columns. If you have a default value, you can create an insert query without that column. With your table, you must give a value to all the null default's columns

answered Sep 27, 2015 at 23:19

Nir Levy

13k3 gold badges23 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DEFAULT NULL column when column created with NOT NULL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related