SQL Help

[nubian]

Originally Posted by Aros

Try this:

ALTER TABLE `vb3_post` ADD COLUMN `warn_flag` int(5) default 0 AFTER attach

This should work if vb3_ is your table prefix set in your config.

vb3 is my prefix.
i got this when i copied and pasted your code.

Error

SQL-query :

ALTER TABLE `vb3_post` ADD COLUMN `warn_flag` int( 5 ) default0 AFTER attach

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