Add A Column To A Table With SQL On A MySQL Database

August - 2021
ALTER TABLE table_name ADD COLUMN column_name details_for_column;

Examples:

ALTER TABLE samples ADD COLUMN id_number INT;
ALTER TABLE genres ADD COLUMN genre VARCHAR(100) NOT NULL UNIQUE;

Note that if you set unique, the values in the table have to be unique already. Same goes for not null.

  • These are for mysql.
  • Need to test with other database.
  • I'm using ADD COLUMN column_name. You can remove COLUMN and call ADD column_name as well, but I like the more explicit version.