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 removeCOLUMN
and callADD column_name
as well, but I like the more explicit version.