[

mysql에서의 subquery

· 2004-11-29 (월) 00:40:18 · 4100
아래는 원본입니다.
http://dev.mysql.com/doc/mysql/en/Subqueries.html

subquery 는 mysql 4.1 부터 적용가능합니다. 고로 지금은 힘들더라도 아쉽지만 노가다를 해야겠네요..ㅠ.ㅠ




A subquery is a SELECT statement inside another statement.

Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific.

With earlier MySQL versions, it was necessary to work around or avoid the use of subqueries, but people starting to write code now will find that subqueries are a very useful part of the MySQL toolkit.

For MySQL versions prior to 4.1, most subqueries can be successfully rewritten using joins and other methods. See section 14.1.8.11 Rewriting Subqueries as Joins for Earlier MySQL Versions.

Here is an example of a subquery:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

In this example, SELECT * FROM t1 ... is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery. We say that the subquery is nested in the outer query, and in fact it's possible to nest subqueries within other subqueries, to a great depth. A subquery must always appear within parentheses.

The main advantages of subqueries are:

They allow queries that are structured so that it's possible to isolate each part of a statement.
They provide alternative ways to perform operations that would otherwise require complex joins and unions.
They are, in many people's opinion, readable. Indeed, it was the innovation of subqueries that gave people the original idea of calling the early SQL ``Structured Query Language.''
Here is an example statement that shows the major points about subquery syntax as specified by the SQL standard and supported in MySQL:

DELETE FROM t1
WHERE s11 > ANY
(SELECT COUNT(*) /* no hint */ FROM t2
WHERE NOT EXISTS
(SELECT * FROM t3
WHERE ROW(5*t2.s1,77)=
(SELECT 50,11*s1 FROM t4 UNION SELECT 50,77 FROM
(SELECT * FROM t5) AS t5)));

Currently, you cannot modify a table and select from the same table in a subquery. This applies to statements such as DELETE, INSERT, REPLACE, and UPDATE.<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
05-03-13 조회 2,433
05-03-13 조회 2,837
05-03-13 조회 2,637
05-03-13 조회 2,676
05-03-13 조회 3,277
05-03-13 조회 2,493
05-03-13 조회 2,409
05-03-13 조회 2,546
05-03-13 조회 3,668
05-03-13 조회 2,703
05-03-13 조회 2,765
05-03-13 조회 2,898
05-03-13 조회 2,712
05-03-13 조회 2,808
05-03-13 조회 2,633
05-03-13 조회 3,003
05-03-13 조회 2,748
05-03-13 조회 3,510
05-03-13 조회 3,228
05-03-13 조회 3,503
05-03-13 조회 2,447
05-03-13 조회 2,522
05-03-13 조회 3,090
05-03-13 조회 2,579
05-03-13 조회 4,659
05-03-13 조회 3,590
05-03-13 조회 3,041
05-03-13 조회 3,720
05-03-13 조회 2,707
05-03-13 조회 2,580
05-03-13 조회 3,516
05-03-13 조회 2,437
05-03-13 조회 2,662
05-03-13 조회 4,171
05-03-13 조회 2,813
05-03-13 조회 2,522
05-03-13 조회 5,832
05-03-13 조회 5,460
05-03-13 조회 4,384
05-03-13 조회 4,683
05-03-13 조회 7,942
05-03-13 조회 4,448
05-03-13 조회 3,522
05-03-13 조회 3,525
05-03-13 조회 8,065
05-03-13 조회 5,540
05-03-13 조회 2,803
05-03-13 조회 4,188
05-03-13 조회 2,882
05-03-13 조회 2,484
05-03-13 조회 3,238
05-03-13 조회 2,702
05-03-13 조회 2,366
05-03-13 조회 2,710
05-03-13 조회 3,892
05-03-13 조회 3,352
05-03-13 조회 2,654
05-03-13 조회 2,579
05-03-12 조회 4,911
05-03-12 조회 3,841
05-03-12 조회 4,540
05-03-12 조회 4,344
05-02-24 조회 4,694
05-02-24 조회 9,466
05-02-23 조회 3,466
05-02-04 조회 4,624
05-02-04 조회 4,093
05-02-04 조회 3,503
05-02-04 조회 3,566
05-02-04 조회 3,492
05-02-04 조회 3,765
04-12-27 조회 3,950
04-12-24 조회 6,230
04-12-22 조회 4,836
04-12-16 조회 5,893
04-12-13 조회 7,125
04-12-11 조회 8,234
04-12-09 조회 1.9만
04-12-08 조회 7,836
04-12-04 조회 3,823
04-12-04 조회 5,045
04-12-01 조회 3,394
04-12-01 조회 5,240
04-12-01 조회 3,838
04-11-30 조회 3,118
04-11-30 조회 3,336
04-11-30 조회 3,106
04-11-30 조회 3,460
04-11-30 조회 2,617
04-11-30 조회 2,463
04-11-30 조회 2,552
04-11-30 조회 3,028
04-11-30 조회 2,799
04-11-30 조회 3,281
04-11-30 조회 4,447
04-11-30 조회 2,500
04-11-30 조회 2,699
04-11-30 조회 4,105
04-11-29 조회 3,260
04-11-29 조회 4,101