【无标题】查询语句

最新推荐文章于 2024-09-30 10:36:33 发布

LJAY3988

最新推荐文章于 2024-09-30 10:36:33 发布

阅读量345

点赞数 13

文章标签： java 数据库前端

本文链接：https://blog.csdn.net/LJAY3988/article/details/139175370

版权

DDL

CREATE TABLE `city` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` char(35) NOT NULL DEFAULT '',
  `CountryCode` char(3) NOT NULL DEFAULT '',
  `District` char(20) NOT NULL DEFAULT '',
  `Population` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `CountryCode` (`CountryCode`),
  CONSTRAINT `city_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `country` (`Code`)
) ENGINE=InnoDB AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1;

DQL

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 CountCode='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 CountCode like 'NL';

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

explain select `Name`,CountryCode,District from city where CountCode in('NLD','PHL');

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