For Techs.... Techniques.... Technologies....


MySQL not showing the UPDATE and INSERT query outputs

The UPDATE and INSERT query provides the outputs when executed in MySQL shell. The same query can be executed from Linux shell using the mysql command with "-e" option. But this will not give any outputs during execution which is the default behavior. So it will be difficult to analyze the query results.

MySQL commandline provides an option to get the execution outputs.

mysql command need to run with -vv option and it will print the query being ran as well as the results.

This will be very helpful in automation scripts.

That's all…