mysql表的删除与修改
- 使用alter table 语句追加,修改或者删除列的语法
CREATE TABLE `emp`(
id INT,
`name` VARCHAR (32),
sex CHAR(1),
birthday DATE,
entary_data DATETIME,
job VARCHAR(32),
Salary DOUBLE,
`resume` TEXT)CHARSET utf8 COLLATE utf8_bin ENGINE INNODB;
INSERT INTO `emp`
VALUES(100,'魈','男','1921-11-11','2021-11-11 11:11:11','降魔大圣','15000.22',
'礼予天地四方');
SELECT *FROM `emp`;
ALTER TABLE `emp`
ADD image VARCHAR(32) NOT NULL DEFAULT''
AFTER RESUME;
DESC `emp`;
ALTER TABLE `emp`
MODIFY `job` VARCHAR(60) NOT NULL DEFAULT '';
ALTER TABLE `emp`
DROP sex;
RENAME TABLE `emp` TO `employee`;
DESC `employee`;
ALTER TABLE employee CHARACTER SET utf8;
ALTER TABLE employee
CHANGE `name` `user_name` VARCHAR(32) NOT NULL DEFAULT'';