数据查询以及union联合查询

最新推荐文章于 2024-09-21 18:46:25 发布

忒吧

最新推荐文章于 2024-09-21 18:46:25 发布

阅读量314

点赞数 2

文章标签：前端 linux javascript

本文链接：https://blog.csdn.net/2401_83904889/article/details/139175025

版权

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 CountryCod like 'NL_';
explain select `Name`,CountryCode,District from city where ='NLD' OR CountryCod='PHL';
explain select `Name`,CountryCode,District from city where CountryCod in ('NLD','PHL');
explain
explain select `Name`,CountryCode,District from city where CountryCod='NLD'
union
select `Name`,CountryCode,District from city where CountryCod='PHL';
explain select `Name` as '姓名' from city where ID>200 limit 10;