如何在MySQL中删除指定数据行？特定行删除操作咨询

要精准删除目标行，避免误删其他account_id=1的数据，按以下步骤操作：

• 先验证条件，确保只选中要删除的行
  执行这条查询，确认返回结果只有你要删除的那一行：

  SELECT * FROM account_external_ids 
  WHERE account_id = 1 
  AND email_address = 'rajesh.m@company.com' 
  AND external_id = 'http://160.155.187.158:8095/openidserver/users/rajesh.m';
  

• 执行删除操作
  确认查询结果正确后，用完全相同的条件执行删除：

  DELETE FROM account_external_ids 
  WHERE account_id = 1 
  AND email_address = 'rajesh.m@company.com' 
  AND external_id = 'http://160.155.187.158:8095/openidserver/users/rajesh.m';
  

• 可选：先备份数据
  如果担心操作失误，可先备份account_id=1的所有行到临时表，方便后续恢复：

  CREATE TABLE account_external_ids_backup AS 
  SELECT * FROM account_external_ids WHERE account_id = 1;
  

内容的提问来源于stack exchange，提问作者user4948798