안녕 하세요..
현재 mysql 5.5를 사용중인데 limit와 not in연산자를 동시에 사용 할수 없나요?
게시판에서 페이징 용도의 쿼리 인데 실행을 할라구 하면 자꾸 에러가 뜨네요..
select seq, thread, depth, subject, writer, readcnt, regdate from board
where thread not in(select thread from board order by thread desc limit 2) order by thread desc limit 2
에러 내용:
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
-----------------------------------------------------------------
select seq, thread, depth, subject, writer, readcnt, regdate from board
where thread not in(select thread from board order by thread desc limit 2) order by thread desc limit 2
|