On Mon, Mar 03, 2003 at 08:21:58AM -0700, Zak Greant wrote:
...
> To keep closer to standard SQL, wrap the SET call in an executable
> comment, like so:
>
> /*! SET table_type=innodb; */
>
> Most (all that I know of :) databases except MySQL will treat the
> comment like a normal multi-line comment. MySQL will strip the comment
> and execute the code.
One note:
The above statement confuses the parser slightly. It believes that the
above statement should continue. This will make the subsequent
statement fail.
I have submitted a bug report. For the short-term, get around the
problem by insterting a second semi-colon. The parser will complain
about an empty query, but the SET statement and the subsequent query
will both succeed.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
MySQL Tip: Display the option files read by the server
% mysqld --help
Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
