X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=mysql%2Fmysql_change_engine.sql;h=43bba943817a55b39b01de8b23b8bbaa62d2dba5;hb=7ee5b682ebc1ee6e2865bad94b4ac6827b6bb769;hp=57c9b5e49c60d5fc74f86a18276f05a037790b88;hpb=ede135aa29342579295ed1bb8676d6671024ba72;p=Pman.Core

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;