Sqlyog writes the mysql stored procedure, sqlyogmysql

Sqlyog writes the mysql stored procedure, sqlyogmysql

Damn it, it's really strange to write a stored procedure fuck, such a simple thing. That is, the number of fucking spaces is less than the number of spaces. It's really troublesome. I spent half a day on it.

DELIMITER // create procedure pro11 () begin declare I INT DEFAULT 0; REPEAT INSERT INTO payout (userId, payOutName, payOutMoney, payOutDate) VALUES (232, "zhangsan", 34, "2013-01-22"); SET I = I + 1; UNTIL I> = 100 END REPEAT; END // DELIMITER;

DELIMITER // create procedure test () BEGINDECLARE I int default 0; WHILE I <100 DOINSERT INTO payout (userId, payOutName, payOutMoney, payOutDate) VALUES (1, "zhangsan", 1, "2013-01-22"); SET I = I + 1; END WHILE; END; // DELIMITER;