mysql的update可以同时更新多张表，多条记录

update employee e,test t set e.salary=555,t.name=’tts’ where e.id=3 and t.id=1UPDATE books,(SELECT bookId,COUNT(id) num FROM library_books WHERE id in (xx,xx) GROUP BY bookId) as tempSET books.bor...

xiaoniuxqq

36272人浏览 · 2018-03-06 16:08:55

xiaoniuxqq · 2018-03-06 16:08:55 发布

update employee e,test t set e.salary=555,t.name=’tts’ where e.id=3 and t.id=1

UPDATE books,(SELECT bookId,COUNT(id) num FROM library_books WHERE id in (xx,xx) GROUP BY bookId) as temp
SET books.borrowNum=books.borrowNum+temp.num WHERE books.id=temp.bookId