2021.11.13Mysql高级查询语句以及unity下gameobject和transform的区别和关联

---

一、Mysql高级语句查询

---

info表

score表

#1.以别名形式查询编号和姓名
selete id 编号,name 姓名from info;

#2.查询编号为1的人的编号和姓名
select id,name from info where id=1;
select id,name from info where name=‘张宇’;

#3.模糊查询
select name,sex from info where name like’张%’;
select naem,age from info where name like’张%‘or name’甘’; like’’;


#4.查询年龄为空的人的姓名和年龄
select name,age from info where age is null;

#5.查询年龄不为空的人的姓名和年龄
select name ,age from info where age is not null;

#6.查询年龄在13-18之间的人的姓名和年龄
select name,age from info where age>=13and age<=18;
select name,age from info where age between 13 and 18;

#7.查询姓名是张宇的人的姓名（唯一的）
select distinct name from info where name=‘张宇’;

#8.按年龄升序查询 人的姓名和年龄
select age,name from info order by age;
select age,name from info order by age asc;

#9.按年龄降序查询 人的姓名和年龄
select age,name from info order by age desc;

#10.按多列排序查询人的编号、姓名、年龄（当年龄相同时才按id排列）
select id,name,age from info order by age,id desc

#11.查询前三条数据（编号 姓名 ）第一页
select id,name,age from info limit 0,3; #0:从0开始 3:总条数
limit id,name from limit 3;

#12.查询两条数据
select id,name from info limit 3,2;

#13.按name降序查询id和name(汉字按拼音首字母排序)
select id,name from info order by convert(name using gbk)desc;