Mysql-e and v simplify code when using mysql-e to generate results to import a specified file: ● to display the statement itself at the same time:-v ● to increase the number of rows of query results: -vv ● to increase the execution time:-vvv can be used in some monitoring scripts to simplify code [plain] (I) without v Testing: [mysql @ even ~] $ Mysql-uroot-poracle-e "select version (); select now ()">/home/mysql/test. SQL [mysql @ even ~] $ Cat/home/mysql/test. SQL VERSION () 5.5.16-log NOW () 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-log 1 row in set -------------- SELECT NOW () ------------ NOW () 18:14:05 1 row in set Bye (3) with 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