Re: dynamic sql in proc

2007-07-02 Thread ViSolve DB Team
); Query OK, 2 rows affected (0.01 sec) +---+ | version() | +---+ | 5.0.18| +---+ 1 row in set (0.00 sec) Thanks ViSolve DB Team. - Original Message - From: "Bryan Cantwell" <[EMAIL PROTECTED]> To: Sent: Friday, June 29, 2007 4:03 AM Subject: dy

dynamic sql in proc

2007-06-28 Thread Bryan Cantwell
I have the following proc... when I run it I get a response that says "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1". I just want a programatic way to upgrade db engine to innodb where I don't