修改表指令
代码
CREATE TABLE `emp`(
id INT,
`name` VARCHAR(4),
`sex` CHAR(5),
birthday DATE,
entry_date DATE,
job VARCHAR(4),
salary FLOAT,
`resume` TEXT);
DROP TABLE emp;
INSERT INTO emp VALUES(1,'ybj','man','2000-07-13','2025-8-1','程序员','25000','我是一个爱学习Java的研究生');
SELECT * FROM emp;
ALTER TABLE emp
ADD image VARCHAR(20) NOT NULL DEFAULT ''
AFTER `resume`
ALTER TABLE emp
MODIFY job VARCHAR(60);
ALTER TABLE emp
DROP sex;
RENAME TABLE emp TO employee;
ALTER TABLE employee CHARSET utf8;
ALTER TABLE employee CHANGE `name` `username` VARCHAR(20);
DESC employee;