RON_ron Posted December 3, 2010 Share Posted December 3, 2010 I want to change the Default value of my db to None. Currently it's Null. Could someone show me the syntax to change the NULL in to None (Default value)? I thought this would work... but no luck.? $sql = "ALTER TABLE my_db MODIFY (name VARCHAR(100) None, mail VARCHAR(100) None, phone TIMESTAMP(30) None)"; mysql_query($sql,$conn); Link to comment https://forums.phpfreaks.com/topic/220549-null-in-to-none/ Share on other sites More sharing options...
trq Posted December 5, 2010 Share Posted December 5, 2010 There is no such type as None. Link to comment https://forums.phpfreaks.com/topic/220549-null-in-to-none/#findComment-1143061 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.