Code Forums - View Single Post

l33t_1-1axx0r · 02-23-2006, 08:49 AM

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?

02-23-2006, 08:49 AM	#1 (permalink)
l33t_1-1axx0r Huzzah! Join Date: Feb 2006 Posts: 8	I'm being yelled at 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?