We can alter an existing table structure using the ALTER TABLE
command, followed by the alteration you want to make:
我们可以使用ALTER TABLE
命令来更改现有的表结构,然后进行您要进行的更改:
ALTER TABLE people ADD COLUMN born_year INT;
This will add a new column with empty values:
这将添加一个具有空值的新列:
age | name | born_year
-----+--------+-----------
37 | Flavio |
8 | Roger |
To drop a column:
删除列:
ALTER TABLE people DROP COLUMN born_year;
This will result in:
这将导致:
age | name
-----+--------
37 | Flavio
8 | Roger
翻译自: https://flaviocopes.com/sql-update-table-structure/