If you use source absolute-pathname from mysql command prompt, then it will execute each statement(or line) in the file individually and print the results exactly in the format you are looking for.
sujay -----Original Message----- From: Jacek Becla [mailto:[EMAIL PROTECTED] Sent: Saturday, October 01, 2005 1:20 AM To: mysql@lists.mysql.com Subject: timing queries? Hi, Does anyone know how to execute SQL statements from a text file such that the summaries "X rows in set (X.YZ sec)" are printed for each query? Neither of these do it: mysql < batch-file mysql -e 'source batch-file' 'source batch-file' run inside mysql command-line does it, but then I need to manually copy and paste the results. Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
