Shell (BASH)-MySQL database operations

Three methods of using shell to operate MySQL Databases

Method 1:
#! /Bin/sh
Mysql-uroot <EOF
[SQL statement]
EOF
The commands between EOF and eof are all MySQL commands. EOF is only a token and can be replaced by other characters.

Method 2:
#! /Bin/sh
SQL = "SQL statement"
Echo $ SQL> "1. SQL"
Mysql-uroot <"1. SQL"
This is not a very good method. Write the statement into the SQL text before importing it into the database.

Method 3:
#! /Bin/sh
Mysql-u root-P password-e "use MySQL; select * from user (SQL statement )";
Exit 0;
Use the command line to directly write MySQL commands to the database.