数据查询以及union联合查询

happy_Cassandra

已于 2024-05-24 15:17:02 修改

阅读量314

点赞数 10

文章标签：数据库 mysql java 前端

于 2024-05-24 15:05:33 首次发布

本文链接：https://blog.csdn.net/happy_daen/article/details/139174813

版权

1.schooldb库——utf8字符集——utf8_general_ci排序规则———world数据库

2.SQL

explain select * from city where ID>500 limit 10;

explain select`Name`,CountryCode,District from city where District='Utrecht';

explain select`Name`,CountryCode,District from city where CountryCode='NLD';

explain select`Name`,CountryCode,District from city where ID=5;

explain select`Name`,CountryCode,District from city where ID<5;
explain select`Name`,CountryCode,District from city where CountryCode like 'NL_';
explain select`Name`,CountryCode,District from city where CountryCode='NLD' OR CountryCode='PHL';
explain select`Name`,CountryCode,District from city where CountryCode in('NLD','PHL');

#性能最快的方法是union联合查询
explain 
select`Name`,CountryCode,District from city where CountryCode='NLD';
union
select`Name`,CountryCode,District from city where CountryCode='PHL'


explain select`Name` as '姓名' from city where ID>200 limit 10;