[sv1cec]

Originally Posted by nubian

sql syntax help please

ALTER TABLE `".TABLE_PREFIX."post` ADD COLUMN `warn_flag` int(5) default 0 AFTER attach

my prefix is vb3 but

i thought it would be like this:
ALTER TABLE vb3_post ADD COLUMN `warn_flag` int(5) default 0 AFTER attach

but i keep getting a syntax error
MySQL said:


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 'default0 AFTER attach' at line 1

please help

You have not left a space between the word "default" and the zero. I think this is your error. Is it?

I'll wait for you to tell me. I'll have another cigarette.

Rgds