Use Shell in Linux for various operations of the database __ large data

Attached below by ShellThe way the command line does not interactively manipulate the database:


mysql-hhostname-pport-uusername-ppassword-eMySQL-related SQL statements, do not run MySQL in the MySQL prompt, that is, you can operate MySQL in the Shell method.


#!/bin/bash
Hostname= "127.0.0.1" #数据库信息
Port= "3306"
Username= "Root"
password= "Root"
Dbname= "Test_db_test" #数据库名称
Tablename= "Test_table_test" #数据库中表的名称

#创建数据库
Create_db_sql= "CREATE database IF not EXISTS ${dbname}"
Mysql-h${hostname}-p${port}-u${username}-p${password}-E "${create_db_sql}"

#创建表
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} ${dbname}-E "${create_table_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}"