--source include/master-slave.inc --connection slave set global binlog_format = 'row'; --connection master set global binlog_format = 'row'; CREATE TABLE IF NOT EXISTS account (id INT, bid INT, balance DECIMAL(10,2), filler CHAR(255), PRIMARY KEY(id))ENGINE=Falcon; DROP PROCEDURE IF EXISTS test.load; delimiter |; CREATE PROCEDURE test.load() BEGIN DECLARE acct INT DEFAULT 10; DECLARE tmp INT DEFAULT 10; WHILE tmp > 0 DO INSERT INTO account VALUES (acct, 0, 0.0, "FRESH ACCOUNT"); SET acct = acct - 1; SET tmp = tmp -1; END WHILE; END| DELIMITER ;| SET AUTOCOMMIT=0; CALL test.load(); SET AUTOCOMMIT=1; connect (thread1, localhost, root,,); connection thread1; SET AUTOCOMMIT=0; START TRANSACTION; UPDATE account SET balance = 5, filler = 'account updated' WHERE id = 5; COMMIT; SET AUTOCOMMIT=1;