mysql - 如何查明 MySQL 中的语法错误

Question

在这个简单的过程中，我无法查明语法错误，这让我发疯了。

DELIMITER $$
DROP PROCEDURE IF EXISTS address_insert$$
CREATE PROCEDURE address_insert()
BEGIN
DECLARE i INT DEFAULT (SELECT COUNT(*) FROM hoop.address);
DECLARE counter INT DEFAULT 0;

WHILE counter < 5 DO 
SET i = i + 1;

INSERT INTO hoop.address (adr_id, address, city, country, created_at, lat, lng, updated_at, zip)
VALUES                   (i, CONCAT("Address-", i), "City", "United States", CURRENT_TIMESTAMP, (SELECT RAND() * (68-60) + 60), (SELECT RAND() * (65-55) + 55), CURRENT_TIMESTAMP, "ZIPCODE"); 

SET counter = counter + 1; 
END WHILE;
END$$
DELIMITER ;

标签： mysqlsqlsyntaxproceduredbeaver

Answer 1

[UPDATEA]

Figured out that the primary problem is that mysql somehow doesn't create my function at all. Which is weird, considering I have all privileges for creation in the database. Any guesses why that could be?