ibatis mysql rownum

 

SET @n := 0;
SELECT @n := @n + 1 number, column1, column2
FROM [TABLE_NAME]

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';

SET @n := 0;
SELECT @n := @n + 1 number, column1, column2
FROM (SELECT @n := 0) dummy, [TABLE_NAME]

이건 pk없을때 쓸거 view페이지에서 jstl로 구현했더니 지저분해져서 쿼리로

SELECT 
b.*
FROM (
SELECT 
    @RNUM:=@RNUM+1 AS ROWNUM , 
    a.*
FROM 
    (SELECT @RNUM:=0) R, 
    (SELECT * FROM board)a 
) as b
LIMIT 3 , 4