mysql常用语句

数据库

如何建库建表
建表常用数据类型（int、bigint、varchar、longtext）

sql语句实现增、删、改、查

select version();//查询mysql版本
use myblog;  //使用某数据库
-- show tables; //-- 代表注释,展示数据表格
insert into users(username,`password`,realname) values('lisi','123','李四');//插入语句,注意password关键字写法``
select * from users;//*查询全部，一般不建议
select id,username from users;
select * from users where username='zhangsan';//条件查询
select * from users where username='zhangsan' and password='123;//多条件查询
select * from users where username='zhangsan' or password='123;//多条件查询
select * from users where username like '%zhang%';//模糊查询username里包含zhang
select * from users where username like '%zhang%' order by id;//排序
select * from users where username like '%zhang%' order by id desc;//倒序
update users set realname='李四2',content='lisi' where username='lisi';//修改
SET SQL_SAFE_UPDATES=0;//safe报错,执行一遍此语句
delete from users where username='lisi';//删除
update users set state='0' where username='liss';//软删除，通过控制状态不是真正的删除