ALTER TABLE
CautionAlter table structure
ALTER TABLE <t> ADD COLUMN <col> <type>;
Adds/drops/retypes columns. On big tables this locks and rebuilds — schedule production changes.
Examples
ALTER TABLE users ADD COLUMN last_login DATETIME;Add a column
Syntax
ALTER TABLE t [ADD|DROP|MODIFY] COLUMN ...;
Before you run it
Long locks on large tables.
Related commands
- CREATE TABLECreate tables
- DESCRIBEDescribe a table
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store