Hello.
There is an example: http://lists.mysql.com/mysql/175004 "Alvaro Cobo" <[EMAIL PROTECTED]> wrote: > Hi guys: > > This is probably an off-topic, and more related to PHP, but it is related to > mysql as well > > I need to execute two insert queries into a single statement from a PHP > application, but it keeps giving me an error. > > I have found this page > (http://dev.mysql.com/doc/mysql/en/c-api-multiple-queries.html), but I don´t > know how to implement it: > > "From version 4.1, MySQL supports the execution of multiple statements > specified in a single query string. To use this capability with a given > connection, you must specify the CLIENT_MULTI_STATEMENTS option in the flags > parameter of mysql_real_connect() when opening the connection. You can also > set this for an existing connection by calling MySQL Reference Manual :: > 23.2.9 C API Handling of Multiple Query Execution mysql_set_server_option > MYSQL_OPTION_MULTI_STATEMENTS_ON) By default, mysql_query() and > mysql_real_query() return only the first query status and the subsequent > queries status can be processed using mysql_more_results() and > mysql_next_result()" > > Does anybody has tried it in php. Does anyone could share an example. > > Thanks and best regards. > > Alvaro. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
