提升mysql 效率
START TRANSACTION;
COMMIT;
START TRANSACTION;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summary=@A WHERE type=1;
COMMIT;
http://xyz.cinc.biz/2013/05/mysql-transaction.html
2018-03-10
提升mysql 效率
- 67
- 0