It really depends on the client. MySQL does not inherently know how to
process multiple statements. If you're sending SQL from a program you
developed, you'll probably have to separate the statements and submit them
individually.
The clients that allow multiple statements (ie urSQL and the mysql
command-line) are somehow handling this on the client-side as MySQL
expects only one SQL statement at a time...
On Fri, 31 Aug 2001, Peter Harvey wrote:
>
> 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.
>
---------------------------------------------------------------------
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
