CREATE TABLE `emp`(
id INT PRIMARY KEY,
`name` VARCHAR(32),
sex CHAR(1),
birthday DATE,
entry_date DATETIME, -- 入职时间
job VARCHAR(32),
salary DOUBLE,
`resume` TEXT
)CHARSET utf8 COLLATE utf8_general_ci ENGINE INNODB;
INSERT INTO `emp` VALUES(2,'jack','男','2012-11-21','2011-02-12 23:11:34','程序员',15200,'从不缺对象');
-- 修改job列,使其长度为60
ALTER TABLE `emp` MODIFY job VARCHAR(60);
-- 删除sex列
ALTER TABLE `emp` DROP sex;
-- 修改表名为employee
RENAME TABLE `emp` TO `employee`; -- charset utf8
-- 修改表的字符集为gbk
ALTER TABLE `employee` CHARACTER SET gbk;
建表的时候设置字符集是utf8,现在变成了gbk
-- 添加一个image列,varchar类型(要求长度40,且在job后)
ALTER TABLE `employee` ADD `image` VARCHAR(40) NOT NULL AFTER job;
-- 将列名name修改为user_name,varchar类型,长度为64
ALTER TABLE `employee` CHANGE `name` user_name VARCHAR(64) NOT NULL DEFAULT '';
DESC `employee`; -- 查看表结构