aysx Posted September 29, 2003 Share Posted September 29, 2003 just a quick question because it slipped my mind how do you set a default value for a column in mysql? thanks Quote Link to comment https://forums.phpfreaks.com/topic/1079-setting-default-in-mysql-tables/ Share on other sites More sharing options...
shivabharat Posted September 29, 2003 Share Posted September 29, 2003 Try this. sample CREATE TABLE `sample` ( `Name` varchar(100) default \'TestName\', `Age` decimal(10,0) default \'20\'); Also refer manual for more details and examples. http://www.phpfreaks.com/mysqlmanual.php Quote Link to comment https://forums.phpfreaks.com/topic/1079-setting-default-in-mysql-tables/#findComment-3672 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.