MySQL Alter Table Add Field Before or After a field already presant

Question

I have this, but it doesn't work:

$query = "ALTER TABLE `".$table_prefix."posts_to_bookmark` 
            ADD `ping_status` INT( 1 ) NOT NULL BEFORE `onlywire_status`";

I appreciate it!

Answer 1

RTFM - MySQL ALTER TABLE Syntax.

Answer 2

$query = "ALTER TABLE `".$table_prefix."posts_to_bookmark` ADD COLUMN `ping_status` INT(1) NOT NULL AFTER `<TABLE COLUMN BEFORE THIS COLUMN>";

I believe you need to have "ADD COLUMN" and also use "AFTER" not "BEfORE".

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html