Adding multiple columns AFTER a specific column in MySQL

The Solution to Adding multiple columns AFTER a specific column in MySQL is


Try this

ALTER TABLE users
ADD COLUMN `count` SMALLINT(6) NOT NULL AFTER `lastname`,
ADD COLUMN `log` VARCHAR(12) NOT NULL AFTER `count`,
ADD COLUMN `status` INT(10) UNSIGNED NOT NULL AFTER `log`;

check the syntax

~ Answered on 2013-07-09 06:32:39


Most Viewed Questions: