1.修改
UPDATE table1
LEFT JOIN table2 ON table1.xx=table2.xx (关联的字段)
SET table1.xx=value,table2.xx=value (update value)
WHERE table1.xx=xx (条件)
2.删除
delete from table1 left join table2 on table1.id = table2.ids where table1.id= ?
1.修改
UPDATE table1
LEFT JOIN table2 ON table1.xx=table2.xx (关联的字段)
SET table1.xx=value,table2.xx=value (update value)
WHERE table1.xx=xx (条件)
2.删除
delete from table1 left join table2 on table1.id = table2.ids where table1.id= ?