sql 조건범위 설정후 삭제

ex) DELETE FROM 테이블 WHERE 컬럼 > 49 AND 컬럼 < 1001

DELETE FROM zetyx_board_comment_diary WHERE no > 49 AND no < 1001

DELETE FROM antisnow.board where title="Viagra"

DELETE FROM antisnow.board WHERE no > 30000 AND no < 80000

DELETE FROM antisnow.board WHERE no > 61000 AND no < 63000

DELETE FROM antisnow.board WHERE no > 64000 AND no < 69000

DELETE FROM antisnow.board WHERE no > 63000

select * from antisnow.board order by no

[출처] sql 조건범위 설정후 삭제 |작성자 우리만수