sql语句 增删改查

-- show tables;

-- 新增

--  insert into users (username,`password`,realname) values ('lisi','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`='123';

-- like 模糊查询

-- select *from users where password like '%1%';

 

--  排序 desc倒序

-- select * from users where password like '%123%' order by id desc;

-- 更新

-- update users set realname='李四2' where username='lisi';

-- 删除

-- delete from users where username = 'lisi';

 

-- 做一个state状态 做软删除 不建议使用delete删除  

-- select * from users where state = '1';

-- update users set state = '0' where username='lisi';