I'm being yelled at

[l33t_1-1axx0r]

alter table 'user' add column 'shouts' integer NOT NULL default = '0'


Using MySQL 5.0.

#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 ''user' add column 'shouts' integer NOT NULL default = '0'' at l


Pretty detailed, huh? Can you not alter table and populate with default value at the same time?

[sde]

try this:

ALTER TABLE `user` ADD `shouts` INT UNSIGNED NOT NULL DEFAULT '0';

[l33t_1-1axx0r]

Thanks