runnerjp Posted May 17, 2007 Share Posted May 17, 2007 Error SQL query: ALTER TABLE `users` ADD `status` ENUM( '0', '1' ) UNSIGNED NOT NULL DEFAULT '0' MySQL said: Documentation #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 'UNSIGNED NOT NULL DEFAULT '0'' at line 1 trying to add a status 0 and 1 but it will not make the table...why??? Quote Link to comment https://forums.phpfreaks.com/topic/51800-solved-error-when-setting-up-a-table/ Share on other sites More sharing options...
jitesh Posted May 17, 2007 Share Posted May 17, 2007 No need to mention unsigned for ENUM ALTER TABLE `users` ADD `status` ENUM( '0', '1' ) DEFAULT '0' NOT NULL Quote Link to comment https://forums.phpfreaks.com/topic/51800-solved-error-when-setting-up-a-table/#findComment-255214 Share on other sites More sharing options...
runnerjp Posted May 17, 2007 Author Share Posted May 17, 2007 oh yer...i have no idea why i set it to unsigned :S ty Quote Link to comment https://forums.phpfreaks.com/topic/51800-solved-error-when-setting-up-a-table/#findComment-255219 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.