Mysql学习mysql子查询使用EXISTS命令的例子

《Mysql学习mysql子查询使用EXISTS命令的例子》要点：
本文介绍了Mysql学习mysql子查询使用EXISTS命令的例子，希望对您有用。如果有疑问，可以联系我们。

本节内容：
mysql子查询使用EXISTSMYSQL应用

sql语句：
?MYSQL应用

/*
mysql> SELECT ArticleID,ArticleTitle
??? -> FROM Articles AS b
??? -> WHERE EXISTS
??? ->??? (
??? ->?????? SELECT ArticleID
??? ->?????? FROM AuthorArticle AS ab
??? ->?????? WHERE b.ArticleID=ab.ArticleID
??? ->??? )
??? -> ORDER BY ArticleTitle;
+-----------+-------------------+
| ArticleID | ArticleTitle????? |
+-----------+-------------------+
|???? 19354 | AI??????????????? |
|???? 15729 | Buy a paper?????? |
|???? 16284 | Conferences?????? |
|???? 12786 | How write a paper |
|???? 19264 | Information?????? |
|???? 17695 | Journal?????????? |
|???? 14356 | Sell a paper????? |
+-----------+-------------------+
7 rows in set (0.01 sec)
*/??????
Drop table Articles;
Drop table Authors;
Drop table AuthorArticle;MYSQL应用

CREATE TABLE Articles (
?? ArticleID SMALLINT NOT NULL PRIMARY KEY,
?? ArticleTitle VARCHAR(60) NOT NULL,
?? Copyright YEAR NOT NULL
)
ENGINE=INNODB;MYSQL应用

INSERT INTO Articles VALUES (12786,'How write a paper',1934),
??????????????????????????? (13331,'Publish a paper',1919),
??????????????????????????? (14356,'Sell a paper',1966),
??????????????????????????? (15729,'Buy a paper',1932),
??????????????????????????? (16284,'Conferences',1996),
??????????????????????????? (17695,'Journal',1980),
??????????????????????????? (19264,'Information',1992),
??????????????????????????? (19354,'AI',1993);MYSQL应用

CREATE TABLE Authors (
?? AuthID SMALLINT NOT NULL PRIMARY KEY,
?? AuthorFirstName VARCHAR(20),
?? AuthorMiddleName VARCHAR(20),
?? AuthorLastName VARCHAR(20)
)
ENGINE=INNODB;MYSQL应用

INSERT INTO Authors VALUES (1006,'Henry','S.','Thompson'),
?????????????????????????? (1007,'Jason','Carol','Oak'),
?????????????????????????? (1008,'James',NULL,'Elk'),
?????????????????????????? (1009,'Tom','M','Ride'),
?????????????????????????? (1010,'Jack','K','Ken'),
?????????????????????????? (1011,'Mary','G.','Lee'),
?????????????????????????? (1012,'Annie','Peng'),
?????????????????????????? (1013,'Alan','Wang'),
?????????????????????????? (1014,'Nelson','Yin');MYSQL应用

CREATE TABLE AuthorArticle (
?? AuthID SMALLINT NOT NULL,
?? ArticleID SMALLINT NOT NULL,
?? PRIMARY KEY (AuthID,ArticleID),
?? FOREIGN KEY (AuthID) REFERENCES Authors (AuthID),
?? FOREIGN KEY (ArticleID) REFERENCES Articles (ArticleID)
)
ENGINE=INNODB;MYSQL应用

INSERT INTO AuthorArticle VALUES (1006,14356),
????????????????????????????? (1008,15729),
????????????????????????????? (1009,12786),
????????????????????????????? (1010,17695),
????????????????????????????? (1011,
????????????????????????????? (1012,19264),19354),
????????????????????????????? (1014,16284);
?MYSQL应用

查询实例：
?MYSQL应用

欢迎参与《Mysql学习mysql子查询使用EXISTS命令的例子》讨论，分享您的想法，编程之家PHP学院为您提供专业教程。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!