数据库增删改查

insert into employee(id,name,sex,birthday,entry_date,salary,resum)
values(1,'zhangsan','male','1993-03-04','2016-11-10','1000','i am a developer');

update employee set salary=5000;

delete from employee where job='zhangsan';

select id,name,chinese,english,math from student;

增删改查语句
操作 命令
增 insert
删 delete
改 update
查 select或者show

库操作
操作 代码
创建数据库 create database shujuku;
创建带字符集的数据库 create database mydb2 CHARACTER SET = utf8;
创建带校验的数据库
create database mydb3 CHARACTER SET = utf8 COLLATE utf8_general_ci;
显示数据库 show databases;
删除数据库 drop database shujuku;
修改数据库编码 alter database shujuku character set gb2312;