安装步骤:https://blog.csdn.net/m0_49284219/article/details/121972531
查询
查询所有内容
select * form user where 1
查询某个用户
select * form user where name=‘zeng8’ and password=’zmm123‘
分数大于500
select * form user where score>500
name zeng_的
_代表任意一个字符(10出不来,8和9能出来)
%代表一个或者多个字符
select * form user where name like ‘zeng_’
select * form user where name like ‘zeng%’
查询所有用户,从1开始,截取2条
select * form user where 1 limit1,2
查询所有用户,按分数排序,升序acs ,降序desc
select * form user where 1 order by score asc
查询两个字段
select name ,score form user where 1
插入
单词:
insert 插入
into 到
user 表明
values 值
inster into user(name,password,score)
values('zeng11','zmm123',120)
修改
把zeng8的分数改为2500
Updata user set score =2500 where name = “zeng8”
把zeng——分数改成2500 —代表任意字符
Updata user set score =2500 where name like “zeng8”
updata 更新
删除
DELETE from users where id = 3
删除users中id为3的行