English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

3 answers

Make that column allows null values, then enter .
But U better use an old value instead of NULL. A value like 01/01/1900

2006-07-03 00:31:20 · answer #1 · answered by Nasmi 2 · 0 0

use the keyword NULL

eg

insert mytable
values (this, that, NULL, somethingelse)

Edit:
of course, i am assuming the column allows nulls - if it has a not null constraint then you can't insert a null

2006-07-03 00:21:15 · answer #2 · answered by Ivanhoe Fats 6 · 0 0

use not null property in to your database and insert null using

INSERT INTO databasename VALUES('one','two',0,'three')

2006-07-03 00:28:42 · answer #3 · answered by jacky 2 · 0 0

fedest.com, questions and answers