While running MySQL statements in batch mode, how can we print, along with output, which statements are getting executed?

MySQLMySQLi Database

By using –v option in batch mode, the MySQL statements can be printed along with output. For example, after running the same query in batch mode with –v option we will get the statement printed along with output.

C:\Program Files\MySQL\bin>mysql -u root -p gaurav < hh.sql -v
Enter password: *****

--------------
select * from hh
--------------
id
1
2

It is showing the statement select * from hh which is written in the file hh.sql.

raja
Published on 21-Feb-2018 07:06:06
Advertisements