MySQL EXIST / NOT EXIST

database/MYSQL 2012. 3. 21. 18:59

http://dev.mysql.com/doc/refman/5.0/en/exists-and-not-exists-subqueries.html


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

t2가 존재한다면 t1을 SELECT 하게 된다..



Posted by 공간사랑
,

티스토리툴바