mysql第二天

修改表

#员工表emp 增加一个iamge列,VARCHAR类型(要求在resume后面)。
/*ALTER TABLE emp ADD image1 VARCHAR(32) NOT NULL DEFAULT '' AFTER resume;*/
#修改job列，使其长度为60
#ALTER table emp MODIFY  job VARCHAR(60);
#删除性别字段
#ALTER TABLE emp drop sex;
#修改表的字符集
#alter TABLE employee CHARSET utf8;
#修改表名 
#RENAME TABLE emp to employee;
DESC employee;
#将列名name修改为user_name
ALTER TABLE employee change name username varchar(255) not null DEFAULT '';

插入

CREATE TABLE goods(

  id int not null,
    goods_name VARCHAR(30),
    price double DEFAULT 1000
) charset utf8;
DESC goods;
INSERT INTO goods VALUES(10,'华为手机',5000);
INSERT into goods values(20,'iphone',6000);
INSERT into goods  VALUES(30,'小米手机',4000) ,(40,'不买手机',DEFAULT);
select * from  goods;
DELETE FROM goods where price  is null;

删除

SELECT * FROM `goods`

DELETE from employee;
UPDATE goods set price=0 where goods_name ='华为手机'; 
# DELETE仅能删除表中记录，不能删除表,删除表用drop table 表名

查询