Error in MySQL Workbench Forward Engineered Stored Procedures
Posted
by colithium
on Stack Overflow
See other posts from Stack Overflow
or by colithium
Published on 2010-05-28T08:56:44Z
Indexed on
2010/05/28
9:21 UTC
Read the original article
Hit count: 308
mysql
|mysql-workbench
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
© Stack Overflow or respective owner