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;
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
- These are for mysql.
- Need to test with other database.
- I'm using
ADD COLUMN column_name. You can remove
ADD column_nameas well, but I like the more explicit version.