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


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.

Updated on: 11-Feb-2020

167 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements