老大最近新引入一个nodejs开发的wolf权限管理系统，所以作为前端也要简单的去学一些server端的知识了，今天简单学习了下mysql增删改查语句，简单做个如下总结：
增加
inset into blogs(title, content,author) values(‘标题’,‘内容’,‘张三’)
select * from blogs // 插入之后查询验证一下
查询
select * form user where username=“zhangsan” or password=“123” // =精确查询
select * for user where username like “%#$zhang^” // like 模糊查询
select * for user order by id in desc //通过id倒叙排序
修改
SET SQL_SAFE_UPDATES = 0;
update users set username=“李四2” where username=“lisi”
删除
delete from users where username=“lisi” <>’0’ //不等于0
软删除 通过state状态来控制
select * from users where state=“1”
Update users set state=“0” where username =“Lisi”
......
