From: Alan Knowles <alan@roojs.com>
Date: Thu, 18 Jun 2015 06:02:44 +0000 (+0800)
Subject: mysql/mysql_change_engine.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=7ee5b682ebc1ee6e2865bad94b4ac6827b6bb769

mysql/mysql_change_engine.sql
---

diff --git a/mysql/mysql_change_engine.sql b/mysql/mysql_change_engine.sql
index 57c9b5e4..43bba943 100644
--- a/mysql/mysql_change_engine.sql
+++ b/mysql/mysql_change_engine.sql
@@ -8,7 +8,6 @@ delimiter $$
 CREATE PROCEDURE mysql_change_engine(mytb TEXT)
     BEGIN
     DECLARE mydb TEXT;
-    DECLARE ConvertEngineSQL TEXT;
     
     SELECT database() INTO mydb;
     
@@ -20,7 +19,7 @@ CREATE PROCEDURE mysql_change_engine(mytb TEXT)
             CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
         )
     INTO
-        ConvertEngineSQL
+        @ConvertEngineSQL
         
     FROM (
         SELECT
@@ -49,7 +48,7 @@ CREATE PROCEDURE mysql_change_engine(mytb TEXT)
     ) AA;
             
     -- SELECT ConvertEngineSQL; -- ???
-    PREPARE st FROM ConvertEngineSQL;
+    PREPARE st FROM @ConvertEngineSQL;
     EXECUTE st;
     DEALLOCATE PREPARE st;