Sarah
0
Q:

do we need to specify commit to save changes in mysql

BEGIN;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summmary=@A WHERE type=1;
COMMIT;
1
SET AUTOCOMMIT=0
0

New to Communities?

Join the community