NULL value not inserted
Posted: Mon Jun 21, 2004 4:04 am
my code is like this
datatype of dep_time is 'time'.
this query doesnt insert NULL rather inserts '00:00:00'
anybody can tell me how to insert NULL value
Code: Select all
update train
set dep_time='NULL' where st_id=2;this query doesnt insert NULL rather inserts '00:00:00'
anybody can tell me how to insert NULL value