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;
数据查询以及union联合查询
最新推荐文章于 2024-10-04 00:46:18 发布