mysql update、delete left join 操作

1 delete

删除多表
DELETE q,pq from com_purchasequote q LEFT JOIN com_purchasequote_snapshoot pq on q.id=pq.id
where q.id=84110;
删除一张表
DELETE q from com_purchasequote q LEFT JOIN com_purchasequote_snapshoot pq on q.id=pq.id
where q.id=82347;
DELETE pq from com_purchasequote q LEFT JOIN com_purchasequote_snapshoot pq on q.id=pq.id
where q.id=67710;

2 多表更新

UPDATE sys_user u left join com_company c on u.companyId = c.id 
SET u.name = '供应商来了' ,c.companyName='供应商公司来了' 
where u.userName='gys';


SELECT u.name,c.companyName from sys_user u left join com_company c on u.companyId = c.id   
where u.userName='gys'