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 -v or --verbose
--verbose) you will get the "X rows in set" message, but you will also
get the SQL statements in the output.
C:> mysql -vv -e 'select 2+2'
--------------
select 2+2
--------------
+-----+
| 2+2 |
+-----+
| 4 |
+-----+
1 row in set (0.00 sec)
Bye
C:>
You can combine with --skip-column-names and --batch to change the output.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
