MySQL -hhostname体育-uusername -ppassword -e 相关mysql的sql语句,不用在mysql的提示符下运行mysql,即可以在shell中操作mysql的方法。
,
# !/bin/bash
主机名=?92.168.111.84",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,端口=?306“
用户名=皉oot"
密码=啊?/p>
DBNAME=皌est_db_test",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,表名=皌est_table_test",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,
create_db_sql=按唇ㄊ菘馊绻淮嬖? {DBNAME}“
mysql - h ${主机名},港口- p $ {},密码- u $ {USERNAME} - p $ {},,“$ {create_db_sql}“
,
create_table_sql=按唇ū砣绻淮嬖?{表}(,名字varchar (20), int id(11)默认0)“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元,“$ {create_table_sql}“
,
insert_sql=安迦?{表}的值(& # 39;billchen& # 39; 2)“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元“$ {insert_sql}“
,
select_sql=皊elect * from ${表}“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元,“$ {select_sql}“
,
update_sql=案?{表}组id=3“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元,,“$ {update_sql}“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元,,“$ {select_sql}“
,
delete_sql=吧境?{表}“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元,,“$ {delete_sql}“
mysql - h ${主机名},港口- p $ {},- u $ {USERNAME} - p{密码}}{DBNAME美元,,“$ {select_sql}“