On 01-Sep-2001 Peter Harvey wrote:
> MySQL
>
> Anyone know what the deal is with sending multiple statements to the
> server and getting errors at ";\n" on the first statement? Even the
> result will come back with something other than '\n' in error messages.
>
> I am using MyODBC but I am not certian that it is a MyODBC behaviour.
>
Correct, It's not.
> Any pointers appreciated.
>
Don't use multiple statements in a program application, only one valid SQL
query without the semi-colon.
The 'qry;qry;' thingy is a feature of the mysql client.
> Peter
>
> BTW: '\n' chars are fine in a statement... just not between statements.
>
'\n' is whitespace, -- ';' isn't.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
---------------------------------------------------------------------
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
