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

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.