Alter table add multiple columns http://stackoverflow.com/questions/17541312/alter-table-add-multiple-columns-after-column1/17541485#17541485

alter_table_add_multiple_colums.sql

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`;