From 7ee5b682ebc1ee6e2865bad94b4ac6827b6bb769 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Thu, 18 Jun 2015 14:02:44 +0800
Subject: [PATCH] mysql/mysql_change_engine.sql

---
 mysql/mysql_change_engine.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

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;
 
-- 
2.39.2