Dan,
>I tried using prepared statements to make a procedure that
>converts every table in a schema from ARCHIVE to MyISAM...
"The following SQL statements can be used in prepared statements: CREATE TABLE, DELETE,
DO, INSERT, REPLACE, SELECT, SET, UPDATE, and
most SHOW statements. Other statem
e END REPEAT;
CLOSE cur1;
END; //
delimiter ;
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 18, 2006 2:16 PM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Subject: Re: Procedure / Prepared statements error converting table
"Burke,
"Burke, Dan" <[EMAIL PROTECTED]> wrote on 01/18/2006 02:05:24 PM:
>
> I tried using prepared statements to make a procedure that converts
> every table in a schema from ARCHIVE to MyISAM (there's about three
> dozen archive tables here). But for some odd reason it will give an
> error after doin
I tried using prepared statements to make a procedure that converts
every table in a schema from ARCHIVE to MyISAM (there's about three
dozen archive tables here). But for some odd reason it will give an
error after doing the first table, and abort. The really odd thing is
that the table it give
