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