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&