Mysql Modify Table Sql

Mysql sql

  • add column after column:

    1
    ALTER TABLE TABLE_NAME ADD COLUMN_NAME VARCHAR(100) AFTER COLUMN_NAME;

  • add multiple columns after one column:

    1
    2
    3
    4
    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`;

  • change column to unique:

    1
    ALTER TABLE TABLE_NAME ADD CONSTRAINT constr_ID UNIQUE (user_id, game_id, date, time);

  • delete column:

    1
    ALTER TABLE table_name DROP COLUMN column_name

  • change column type:

    1
    ALTER TABLE table_name MODIFY COLUMN column_name VARCHAR(100) NOT NULL