数据库库班作业四

查看mysql库下的表
SHOW TABLES FROM mysql;

查看其中两张表结构
DESCRIBE db;

DESCRIBE func;

修改字段名emp_birth为birth
ALTER TABLE employees CHANGE emp_birth birth DATE;

给emp_sex字段修改数据类型类char(1)添加非空约束
ALTER TABLE employees MODIFY emp_sex VARCHAR(2) NOT NULL;

添加和删除note字段
ALTER TABLE employees ADD note VARCHAR(5);
ALTER TABLE employees DROP note;

添加 favoriate_activity数据类型VARCHAR(100)
ALTER TABLE employees ADD favoriate_activity VARCHAR(100);

删除offices表
DROP TABLE offices;

将employees表重命名为employees_info
ALTER TABLE employees RENAME employees_info;