mysql delete update sql

DELETE a FROM ads_server_mapping_queue a,
ads_server_info b where a.MachineId=b.MachineId and b.SN='{0}' and b.AssetId='{1}'

 

update equipment_position a,t_device b,idc_position c
set c.status=0
where a.equipmentid=b.id and a.configitemid= 2 and b.servertypeid=5
and positionid !=0 and c.id =a.positionid;