sql添删改查

#查询
select * from sys_user;

#添加
insert into sys_user(username,`password`,phone,create_time) values('tom','123456','18306500667','2021-6-1')

#修改
update sys_user set username='admin',phone='13386459867' where user_id = 1

#删除
delete from sys_user  where user_id = 2

#模糊查询
select * from sys_user where username like '%tom%'


#对 parent_id 进行去重复
select distinct parent_id from sys_menu


#order by 排序， desc按倒序排序，默认不写按正序排序
select * from  users order by addTime desc


#group by 分组
select *,count(parent_id) from sys_menu group by parent_id


#获取前5条数据 SQL server 支持
select top 5 * from users

#获取前5条数据 MySQL支持
select * from user where limit 0,5


#把name包含 菜单管理、角色管理、系统管理 查找出来
select * from sys_menu where  name in ('菜单管理','角色管理','系统管理')


#把1200 到 1400之间的查出来
select * from sys_menu where menu_id between 1200 and 1400