mysql中删除一条数据

-- 删除单条记录
DELETE FROM table_name WHERE id = 1;

-- 删除多条记录
DELETE FROM table_name WHERE age > 30;

-- 确认数据存在
SELECT * FROM table_name WHERE id = 1;

-- 如果数据不存在，可以忽略删除操作或更新数据
UPDATE table_name SET status = 'deleted' WHERE id = 1;

-- 先删除外键引用的数据
DELETE FROM related_table WHERE foreign_key = 1;

-- 再删除主表中的数据
DELETE FROM table_name WHERE id = 1;

-- 使用分批删除
DELETE FROM table_name WHERE id > 1000 LIMIT 1000;

-- 或者使用临时表
CREATE TEMPORARY TABLE temp_table AS SELECT * FROM table_name WHERE id > 1000;
DELETE FROM table_name WHERE id IN (SELECT id FROM temp_table);
DROP TEMPORARY TABLE temp_table;