1.在原有表中添加一列
ALTER TABLE table-name ADD COLUMN column-name column-type
例如在student表中添加一列名为name,类型为varchar:
alter table student add column name varchar;
1.在原有表中添加一列
ALTER TABLE table-name ADD COLUMN column-name column-type
例如在student表中添加一列名为name,类型为varchar:
alter table student add column name varchar;