dayang Posted May 20, 2009 Share Posted May 20, 2009 i has table outbox which has value insertdate that default=Null so the problem is i want to create like above field=insertdate type=datetime Null=No Default=0000-00-00 00:00:00 my coding is alter table outbox modify insertdate datetime NOT NULL; i think my code is wrong.who can help me..... Link to comment https://forums.phpfreaks.com/topic/158883-date/ Share on other sites More sharing options...
waynew Posted May 20, 2009 Share Posted May 20, 2009 insertdate DATETIME NOT NULL ??? Link to comment https://forums.phpfreaks.com/topic/158883-date/#findComment-837969 Share on other sites More sharing options...
pdkv2 Posted May 20, 2009 Share Posted May 20, 2009 USE ALTER TABLE table_name MODIFY column_name column_type; By the way please post this topic in DB related forum Link to comment https://forums.phpfreaks.com/topic/158883-date/#findComment-837970 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.