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); Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/220549-null-in-to-none/#findComment-1143061 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.