At 11:35 +0000 3/20/02, Javier wrote: >Hi, > >I have a text file , with several MySQL instructions (CREATE TABLE, INSERT, >SET @var, etc.). > > I want to execute all these instructions from a C program , using the API. > >It is possible to use the function mysql_query(), to execute all the >instructions contained in the file in a single call to this function? , Can >I execute several MySQL instructions in one only call to mysql_query() >function?
No. Not for the C API, or for any API. The client-server protocol requires that you issue a single query at at time. But there's nothing to stop you from writing a utility function that takes all the statements and issues them. Then you just call *that* function once. And remember that you don't include a terminating semicolon on the statements when you use an API. > >If it is possible, which is the best way to do this? > >Thanks in advance > >Javier Diaz >IT Developer --------------------------------------------------------------------- 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