MySql 常用命令
时间：2021-07-01 10:21:17
帮助过：33人阅读
-- insert into users(username,`password`,realname)values(
‘zhangsan‘,
‘123‘,
‘张三‘);
--
select *
from users;
--
select id,username
from users;
--
select *
from users
where username=
‘zhangsan‘and `password`=
‘123‘;
--
select *
from users
where username=
‘zhangsan‘or `password`=
‘121‘;
--
select *
from users
where username like
‘%zhang%‘;
--
select *
from users
where password like
‘%1%‘ order by id desc ;
MySql 常用命令
标签：删除 int info from src password img 数据库 常用命令
