Question

MYSQL删除表中多条记录的语句

如我想删除表A中ID=50~150之间的100条记录，该怎么写，我自己写了一行：DELETE FROM 'A' WHERE chapterid > '49' AND chapterid < '151'

提示语法错误，本人不会数据库语言，请高手指点，谢谢
我就是这样写的呀，但是返回信息是语法错误

Answer 1

DELETE FROM `A` WHERE chapterid > 49 AND chapterid < 151
或者试试
DELETE FROM `A` WHERE chapterid > '49' AND chapterid < '151'

注意 `和'的区别

前者是 键盘tab键上面的符号，后者是单引号

Answer 2

表名不能加引号的,去掉引号你试下,不行的话用下面这个试试看.
DELETE FROM A WHERE chapterid between '50' AND '151'

Answer 3

DELETE FROM A WHERE chapterid > 49 AND chapterid < 151