增删改查的语句命令为:
增:insert create
删:delete drop
改:update alert
查:select
库操作
创建数据库:create database company charset utf8;
显示数据库:show databases;
删除数据库:drop database company;
表操作
创建数据库表:create table employee (id int auto_increment PRIMARY KEY, name varchar(40), sex char(4), birthday date, job varchar(100));
表名改为user:rename table employee to user;
为表增加一列:alter table user add salary Integer;
修改列的名称:alter table user change column name username varchar(100);
修改列的属性:alter table user modify job varchar(60);
删除sex列:alter table user drop sex;
修改表的字符集:alter table user character set utf8;
查看表结构:desc user;
删除表:drop table user;
数据操作
插入数据:insert into user (id,name,birthday,salary,resume) values(1,'woniu','1993-03-04','1000','i am a man');
修改数据:update user set salary = 10000 where name='woniu';
删除数据:delete from user where job='ccc';
清空数据:delete from user; 或者 truncate table user;
查找数据:select salary from user where name='woniu';
select name,salary from user where id>=15 and id<=20; 查询id在15到20间的相应信息
select * from user where left(name, 2)='wo'; 查询name前两位是'wo'开头的信息