Use the MYSQL-E parameter to execute various operation statements of various SQL. Instead of running MySQL at the prompt of MySQL, you can manipulate MySQL in the shell.
Format: Mysql-hhostname-pport-uusername-ppassword-e ""
#!/bin/bash
Hostname= "192.168.70.161" #数据库服务器地址
Port= "3306"
Username= "Root"
Password= "123456"
Dbname= "Test_db_test" #数据库名称
Tablename= "Test_table_test" #数据库中表的名称
#也可以写 hostname= "localhost", port number port can not be set
#创建数据库
Create_db_sql= "CREATE database IF not EXISTS ${dbname}"
Mysql-h${hostname}-p${port}-u${username}-p${password}-E "${create_db_sql}"
Note: There can be no spaces in the middle of-p${password}
#创建表
Create_table_sql= "CREATE table IF not EXISTS ${tablename} (name varchar (), id int (one) default 0)"
Mysql-h${hostname}-p${port}-u${username}-p${password}-D ${dbname}-E "${create_db_sql}"
#插入数据
Insert_sql= "INSERT INTO ${tablename} values (' Billchen ', 2)"
Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${insert_sql}"
#查询
Select_sql= "SELECT * FROM ${tablename}"
Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${select_sql}"
#更新数据
update_sql= "Update ${tablename} set id=3"
Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${update_sql}"
Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${select_sql}"
#删除数据
Delete_sql= "Delete from ${tablename}"
Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${delete_sql}"
Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${select_sql}"
MySQL uses a shell script to link the database for operation