mysql> DELIMITER //
mysql>
mysql> CREATE PROCEDURE bulk_insert_hash()
→ BEGIN
→ DECLARE i INT DEFAULT 1;
→ WHILE i < 10001 DO
→ INSERT INTO t_p_hash (c1, c2, c3) VALUES (‘a’, i, i);
→ SET i = i + 1;
→ END WHILE;
→ END //
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘PROCEDURE bulk_insert_hash()
BEGIN
DECLARE i INT DEFAULT 1;’ at line 1
mysql>
mysql> DELIMITER ;
ob社区版 4.x才开始支持存储过程 尽量使用4.x的版本