beennn Posted July 22, 2011 Share Posted July 22, 2011 how can i set a default value for an integer?iv tried:luck int DEFAULT '0'but im returned:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' luck int DEFAULT '0' at line 4EDIT: My mistake; i didnt realise i needed to put ADD in front of every new collum i wanted. Link to comment Share on other sites More sharing options...
niche Posted July 22, 2011 Share Posted July 22, 2011 You might consider phpmyadmin. It handles the administration of one or more MySQL servers over the web. It's free download at http://www.phpmyadmin.net/home_page/index.php Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.