explain SELECT * FROM city where ID>500 limit 10;
explain SELECT `Name`,CountryCode,Diserict from city where District='Utrecht';
explain SELECT `Name`,CountryCode,Diserict from city where CountryCode='NLD';
explain SELECT `Name`,CountryCode,Diserict from city where ID=5;
explain SELECT `Name`,CountryCode,Diserict from city where ID<5;
explain SELECT `Name`,CountryCode,Diserict from city where CountryCode like 'NL_';
explain SELECT `Name`,CountryCode,Diserict from city where CountryCode='NLD' OR CountryCode='PHL';
explain SELECT `Name`,CountryCode,Diserict from city where CountryCode in('NLD','RHL');
explain SELECT `Name`,CountryCode,Diserict from city where CountryCode='NLD'
union
SELECT `Name`,CountryCode,Diserict from city where CountryCode='PHL';
SQL简易优化
最新推荐文章于 2024-06-15 20:21:51 发布