查询语句
select 查询的字段名 from 表 where 条件
where
模糊查询
select * from class where email like "%qq%";
select * from class where email like "ja%"; // ja 开头的
select * from class where email like "%163.com"; //163 结尾的
select * from class where email not like "%163.com"; //不是 163 结尾的
//统计数据条数
select count(1) from users
//统计列中最大值
select max(列名) from users
//统计一列之和
select sum(列名) from users
mysql别名
//将查出来的name改名为username
select name as username from users
关联查询(最好别用关联查询,效率低)
笛卡尔积关联查询效率较低,一般用内连接
插入数据
insert into users(username,id) values('zhangsan',1);
修改数据
update users set username='zyf' where username='zhangsan';
删除数据
delete from users where username='zyf';