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,
Jacek Becla wrote:
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'
If you add verbosity using the parameter -vv (or -v