Hi, > In using the application there is one feature I see missing. > > 1. Inability to execute multiple statements in sequence. If you are talking about the MySQL command-line client program, then you definitely can execute multiple statements at once, just by making sure you terminate each statement with ';', '\g' or '\G'. For example: mysql> select 1 + 1; select 2 + 2; +-------+ | 1 + 1 | +-------+ | 2 | +-------+ 1 row in set (0.00 sec) +-------+ | 2 + 2 | +-------+ | 4 | +-------+ 1 row in set (0.00 sec) You can even create a 'script' of SQL statments in a text file to be executed in sequence by the MySQL client program. Simply run MySQL like this: $ mysql -u username -p databasename < scriptfile.sql Or, you can run the 'script' from within the program by using the 'source' command. Type 'help' within the client for details on this and other handy commands. However, if you're talking about a third-party client application or about trying to do this from a PHP script (via the mysql_query() function) then I doubt it will be possible - definitely not possible in the case of PHP. Regards, ------------------------------------------------ Basil Hussain ([EMAIL PROTECTED]) --------------------------------------------------------------------- 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
