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...