Styjun

How far did Gandalf and the Balrog drop from the bridge in Moria?

How to Check all AD userers for "blank" password?

Why is statically linking glibc discouraged?

The cat exchanges places with a drawing of the cat

Do beef farmed pastures net remove carbon emissions?

What is a good class if we remove subclasses?

How to take the beginning and end parts of a list with simpler syntax?

What are these funnel-looking green things in my yard?

The cat ate your input again!

How do you deal with the emotions of not being the one to find the cause of a bug?

If "more guns less crime", how do gun advocates explain that the EU has less crime than the US?

A torrent of foreign terms

PhD advisor lost funding, need advice

Running code generated in realtime in JavaScript with eval()

What are those bumps on top of the Antonov-225?

How can God warn people of the upcoming rapture without disrupting society?

Update Office without opening an Office application

Super Duper Vdd stiffening required on 555 timer, what is the best way?

Can renaming a method preserve encapsulation?

Programmatically add log information in all renderings(controller, view) html

What is the difference between 王 and 皇?

Is this n-speak?

Why did IBM make public the PC BIOS source code?

Does fossil fuels use since 1990 account for half of all the fossil fuels used in history?

SQL Stored Procedure - Run a SQL Query

How can I prevent SQL injection in PHP?Add a column with a default value to an existing table in SQL ServerInserting multiple rows in a single SQL query?Insert results of a stored procedure into a temporary tableFunction vs. Stored Procedure in SQL ServerHow do I UPDATE from a SELECT in SQL Server?Create table using rows from another table as columnsSearch text in stored procedure in SQL ServerHow do I import an SQL file using the command line in MySQL?Combine data from multiple columns into a single column using Microsoft Access SQL

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

Here is the way I am creating my stored procedure:

SET @SQL = 
(SELECT ddl_script FROM TABLENAME.versions where ID = 5)
;

USE TABLENAME;
DROP procedure IF EXISTS `ddl_stored_procedure`;

DELIMITER $$
CREATE PROCEDURE `ddl_stored_procedure` ()
BEGIN

PREPARE part1 FROM @SQL;
EXECUTE part1;
DEALLOCATE PREPARE part1;

END$$
DELIMITER ;

This part works fine and my stored procedure is created. Now I try to run my stored procedure with this line of code to test it:

CALL `DBNAME`.`ddl_stored_procedure`();

And I get the error message:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE `xxx_landing`; CREATE TABLE `TABLE1` ( `ROW1` varchar(1), `T' at line 1

The code that is running, is an SQL statement inside one of my databases as longtext and looks like this:

CREATE DATABASE `xxx_landing` /*!40100 DEFAULT CHARACTER SET utf8 */; 
USE `xxx_landing`; 

CREATE TABLE `TABLE1` ( 
 `ROW1` varchar(1), 
 `ROW2` varchar(20), 
 `ROW3` varchar(3) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8; 

CREATE TABLE `TABLE2` ( 
 `ROW4` varchar(2), 
 `ROW5` varchar(10), 
 `ROW6` varchar(10), 
 `ROW7` varchar(10), 
 `ROW8` varchar(10), 
 `ROW9` varchar(50) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8;

I do not know why the stored procedure fails to create the database, use it and create all tables. If I execute the SQL-Query manually there is no syntax error.
Can someone explain me what I am doing wrong?

Thanks in advance!

mysql sql stored-procedures

share|improve this question

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges

add a comment | 

1

Here is the way I am creating my stored procedure:

SET @SQL = 
(SELECT ddl_script FROM TABLENAME.versions where ID = 5)
;

USE TABLENAME;
DROP procedure IF EXISTS `ddl_stored_procedure`;

DELIMITER $$
CREATE PROCEDURE `ddl_stored_procedure` ()
BEGIN

PREPARE part1 FROM @SQL;
EXECUTE part1;
DEALLOCATE PREPARE part1;

END$$
DELIMITER ;

This part works fine and my stored procedure is created. Now I try to run my stored procedure with this line of code to test it:

CALL `DBNAME`.`ddl_stored_procedure`();

And I get the error message:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE `xxx_landing`; CREATE TABLE `TABLE1` ( `ROW1` varchar(1), `T' at line 1

The code that is running, is an SQL statement inside one of my databases as longtext and looks like this:

CREATE DATABASE `xxx_landing` /*!40100 DEFAULT CHARACTER SET utf8 */; 
USE `xxx_landing`; 

CREATE TABLE `TABLE1` ( 
 `ROW1` varchar(1), 
 `ROW2` varchar(20), 
 `ROW3` varchar(3) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8; 

CREATE TABLE `TABLE2` ( 
 `ROW4` varchar(2), 
 `ROW5` varchar(10), 
 `ROW6` varchar(10), 
 `ROW7` varchar(10), 
 `ROW8` varchar(10), 
 `ROW9` varchar(50) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8;

I do not know why the stored procedure fails to create the database, use it and create all tables. If I execute the SQL-Query manually there is no syntax error.
Can someone explain me what I am doing wrong?

Thanks in advance!

mysql sql stored-procedures

share|improve this question

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges

add a comment | 

Here is the way I am creating my stored procedure:

SET @SQL = 
(SELECT ddl_script FROM TABLENAME.versions where ID = 5)
;

USE TABLENAME;
DROP procedure IF EXISTS `ddl_stored_procedure`;

DELIMITER $$
CREATE PROCEDURE `ddl_stored_procedure` ()
BEGIN

PREPARE part1 FROM @SQL;
EXECUTE part1;
DEALLOCATE PREPARE part1;

END$$
DELIMITER ;

This part works fine and my stored procedure is created. Now I try to run my stored procedure with this line of code to test it:

CALL `DBNAME`.`ddl_stored_procedure`();

And I get the error message:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE `xxx_landing`; CREATE TABLE `TABLE1` ( `ROW1` varchar(1), `T' at line 1

The code that is running, is an SQL statement inside one of my databases as longtext and looks like this:

CREATE DATABASE `xxx_landing` /*!40100 DEFAULT CHARACTER SET utf8 */; 
USE `xxx_landing`; 

CREATE TABLE `TABLE1` ( 
 `ROW1` varchar(1), 
 `ROW2` varchar(20), 
 `ROW3` varchar(3) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8; 

CREATE TABLE `TABLE2` ( 
 `ROW4` varchar(2), 
 `ROW5` varchar(10), 
 `ROW6` varchar(10), 
 `ROW7` varchar(10), 
 `ROW8` varchar(10), 
 `ROW9` varchar(50) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8;

I do not know why the stored procedure fails to create the database, use it and create all tables. If I execute the SQL-Query manually there is no syntax error.
Can someone explain me what I am doing wrong?

Thanks in advance!

mysql sql stored-procedures

share|improve this question

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges

SET @SQL = 
(SELECT ddl_script FROM TABLENAME.versions where ID = 5)
;

USE TABLENAME;
DROP procedure IF EXISTS `ddl_stored_procedure`;

DELIMITER $$
CREATE PROCEDURE `ddl_stored_procedure` ()
BEGIN

PREPARE part1 FROM @SQL;
EXECUTE part1;
DEALLOCATE PREPARE part1;

END$$
DELIMITER ;

CALL `DBNAME`.`ddl_stored_procedure`();

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE `xxx_landing`; CREATE TABLE `TABLE1` ( `ROW1` varchar(1), `T' at line 1

CREATE DATABASE `xxx_landing` /*!40100 DEFAULT CHARACTER SET utf8 */; 
USE `xxx_landing`; 

CREATE TABLE `TABLE1` ( 
 `ROW1` varchar(1), 
 `ROW2` varchar(20), 
 `ROW3` varchar(3) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8; 

CREATE TABLE `TABLE2` ( 
 `ROW4` varchar(2), 
 `ROW5` varchar(10), 
 `ROW6` varchar(10), 
 `ROW7` varchar(10), 
 `ROW8` varchar(10), 
 `ROW9` varchar(50) 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8;

share|improve this question

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges

share|improve this question

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges

asked Mar 27 at 10:20

Christoph C.Christoph C.

37111 gold badge1010 silver badges3131 bronze badges