Use Mysql-eWhen the generated result is imported to a specified file:
● To display the statement itself at the same time:-V
● To increase the number of rows in the query result:-VV
● To increase the execution time:-Vvv
Some monitoring scripts can be used to simplifyCode
(I) test without V: [MySQL @ even ~] $ Mysql-uroot-poracle-e "select version (); select now ()">/home/MySQL/test. SQL [MySQL @ even ~] $ CAT/home/MySQL/test. sqlversion () 5.5.16-lognow () 18:06:35 (ii) Bring a V test: [MySQL @ even ~] $ Mysql-uroot-poracle-e "select version (); select now ()"-V>/home/MySQL/test02. SQL [MySQL @ even ~] $ CAT/home/MySQL/test02. SQL -------------- select version () -------------- version () 5.5.16-log -------------- select now () -------------- now () 18:08:40 (3) with two v tests: [MySQL @ even ~] $ Mysql-uroot-poracle-e "select version (); select now ()"-VV>/home/MySQL/test03. SQL [MySQL @ even ~] $ CAT/home/MySQL/test03. SQL -------------- select version () -------------- version () 5.5.16-log1 row in set -------------- select now () ------------ now () row in setbye (3) Three v tests: [MySQL @ even ~] $ Mysql-uroot-poracle-e "select version (); select now ()"-vvv>/home/MySQL/test04. SQL [MySQL @ even ~] $ CAT/home/MySQL/test04. SQL -------------- select version () -------------- + ------------ + | version () | + ------------ + | 5.5.16-log | + ------------ + 1 row in SET (0.00 Sec) -------------- select now () -------------- + ------------------- + | now () | + --------------------- + | 18:14:49 | + ----------------------- + 1 row in SET (0.00 Sec) Bye