MySQL | 修改数据表结构
数据定义语言:字段约束
添加字段
ALTER TABLE student
ADD address VARCHAR(200) NOT NULL,
ADD home_tel char(11) NOT NULL;
修改字段类型和约束
ALTER TABLE student
MODIFY home_tel VARCHAR(20) NOT NULL;
DESC student;
修改字段名称
DESC student;
ALTER TABLE student
CHANGE address h...
hn.icodeq.com1 min read