You can place your statements into a file, e.g. numuser.sql, and redirect this into mysql client:
use mysql; select count(User) from user; F:\MySQL\bin>mysql -uroot < numuser.sql count(User) 4 -----Original Message----- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 9:14 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: How to send multiple statements to the server? Can't be done. I know. I tried. I asked the same question several months ago. I wish we could do so. -----Original Message----- From: root [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:36 AM To: [EMAIL PROTECTED] Subject: How to send multiple statements to the server? Hi! i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in one string separated with ';' but i does not work. some ideas? blestan --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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