Insert NULL value into INT column

Question

How can I insert NULL value into INT column with MySQL  Is it possible

User · Answer

The optimal solution for this is provide it as  0  and while using string use it as  null  when using integer   ex   INSERT INTO table name column name  VALUES NULL

User · Answer

Just use the insert query and put the NULL keyword without quotes  That will work-  INSERT INTO  myDatabase   myTable    myColumn   VALUES  NULL

User · Answer

If column is not NOT NULL  nullable    You just put NULL instead of value in INSERT statement

User · Answer

If the column has the NOT NULL constraint then it won t be possible  but otherwise this is fine   INSERT INTO MyTable MyIntColumn  VALUES NULL

User · Answer

Does the column allow null   Seems to work  Just tested with phpMyAdmin  the column is of type int that allows nulls   INSERT INTO  database   table    column   VALUES  NULL

User · Answer

2 ways to do it     insert tbl  other  col1  intcol  values   abc   123  NULL    or just omit it from the column list     insert tbl  other  col1  values   abc   123

[mysql] Insert NULL value into INT column

Examples related to mysql