DELETE删除数据
课程：SQL · 编程练习
SQL编程练习 - DELETE删除数据
练习内容
-- 删除指定用户\nDELETE FROM users WHERE id = 10;\n\n-- 删除非活跃用户\nDELETE FROM users\nWHERE status = 'inactive' AND last_login < '2023-01-01';\n\n-- 删除重复记录（保留ID最小的）\nDELETE FROM users\nWHERE id NOT IN (\n
课程：SQL · 编程练习
SQL编程练习 - DELETE删除数据
-- 删除指定用户\nDELETE FROM users WHERE id = 10;\n\n-- 删除非活跃用户\nDELETE FROM users\nWHERE status = 'inactive' AND last_login < '2023-01-01';\n\n-- 删除重复记录（保留ID最小的）\nDELETE FROM users\nWHERE id NOT IN (\n