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
