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
Moderator: General Moderators
Code: Select all
update train
set dep_time='NULL' where st_id=2;Code: Select all
update train
set dep_time=NULL where st_id=2;