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 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 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
Archived
This topic is now archived and is closed to further replies.