mysql - 更正用于删除列值在指定范围之间的记录的 MySQL 语法

Question

我想删除 MySQL 表中“id”列中的值大于某个值且小于某个值的所有记录..

我试过这个:

 DELETE FROM `jos_users` WHERE `id` > 1303856 AND 'id' < 2557250 ;

但是发生的是所有记录 > 1303856 都被删除了..包括值为 2557250 和大于 2557250 的 ID...

那么在这种情况下正确的 mysql 查询或语法是什么？

提前致谢..

Answer 1

可以尝试

delete from `jos_users` where id between 1303856 and 2557250

This should work as well. take note of the id and 'id'. Diff between `` and ''

DELETE FROM `jos_users` WHERE `id` > 1303856 AND `id` < 2557250 ;