我想删除表格的最后一行。
查询:
delete from NEXG.user_type where `id`=last_insert_id()
id为自动递增键。
但是显示0行受影响
这背后的原因是什么?
simple:
DELETE FROM `user_type`
ORDER BY `id` DESC
LIMIT 1
我想删除表格的最后一行。
查询:
delete from NEXG.user_type where `id`=last_insert_id()
id为自动递增键。
但是显示0行受影响
这背后的原因是什么?
simple:
DELETE FROM `user_type`
ORDER BY `id` DESC
LIMIT 1