Ways to execute MySQL statements in shell scripts

method One: use the file label EOF redirection method:

#!/bin/bash user=root pass=123456 db=mysql tablename=user mysql-s--line-numbers-f-u$user-p$pass-d $db--delimiter= "; "-e<--select Host,user from $tablename order by 1; SELECT Host,user from $tablename order by 1; Quit EOF

Pros: SQL and Shell can be separated, writing SQL without a relational shell.

method Two : Use the MySQL parameter method

mysql-u$user-p$pass-d $db-E "select host from User;"

Of course, the statements after-E can be passed in a way that passes the arguments.

method Three saves the statement that needs to be executed in each step to tmp.sql, and finally uses the

Mysql-uuname-ppwd < Tmp.sql

This article is from the "-= lake-side Bamboo =-" blog, please be sure to keep this source http://bronte.blog.51cto.com/2418552/1535177