前言:安装完Mysql 后配置完环境正常可以运行;下载 Navicat Premium 安装可进行操作。
一、:查询
1.查询所有内容 select * from user where 1(红色字符为通用字符)
2.查询某个用户
select * from user where name=‘zeng8’ and password=’zmm123‘
3.分数大于500
select * from user where score>500
4.name zeng_的
_代表任意一个字符(10出不来,8和9能出来)
%代表一个或者多个字符
select * from user where name like ‘zeng_’
select * from user where name like ‘zeng%
5.查询所有用户,从1开始,截取2条
select * from user where 1 limit1,2
6.查询所有用户,按分数排序,升序acs ,降序desc
select * from user where 1 order by score asc
select * from user where 1 order by score desc
7. 查询两个字段
select name ,scorefrom user where 1
二、插入
1.单词:
insert插入
into到
user表明
values值
2.insert into user(name,password,score)
values(‘zeng11’,‘zmm123’,120)
3.把zeng8的分数改为2500
update user set score =2500 where name ='zeng8'
把zeng_分数改变2500 _代表任意字符
update user set score =2500 where name like 'zeng_'
三、删除
1.DELETE form user where id=5
删除user中id为5的行