RE: timing queries?

2005-10-01 Thread Sujay Koduri
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,

Re: timing queries?

2005-10-01 Thread Roger Baklund
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