Error in MySQL Workbench Forward Engineered Stored Procedures
- by colithium
I am using MySQL Workbench (5.1.18 OSS rev 4456) to forward engineer a SQL CREATE script. For every stored procedure, the automatic process outputs something like:
DELIMITER //
USE DB_Name//
DB_Name//
DROP procedure IF EXISTS `DB_Name`.`SP_Name` //
USE DB_Name//
DB_Name//
CREATE PROCEDURE `DB_Name`.`SP_Name` (id INT)
BEGIN
SELECT *
FROM Table_Name
WHERE Id = id;
END//
The two lines that are simply the database name followed by the delimiter are errors and are reported as such when running the script. As long as they are ignored, it looks like everything gets created just fine. But why would it add those lines?
I am creating the database in the WAMP environment which uses MySQL 5.1.36
