当前位置: 首页 > >

shell脚本建mysql库和表_shell脚本操作mysql数据库?创建数据库,在该数据库中创建表(插入,查询,更新,删除操作也可以做)...

发布时间:

#!/bin/bash


HOSTNAME="192.168.1.224"?????????????????????????????????????????? #数据库Server信息


PORT="3306"


USERNAME="root"


PASSWORD="123456"


DBNAME="test_db_name"??????????????????????????????????????????? ? #要创建的数据库的库名称


TABLENAME="test_table_name"????????????????????????????????? #要创建的数据库的表的名称


MYSQL_CMD="mysql -h${HOSTNAME}? -P${PORT}? -u${USERNAME} -p${PASSWORD}"


echo ${MYSQL_CMD}


echo "create database ${DBNAME}"


create_db_sql="create database IF NOT EXISTS ${DBNAME}"


echo ${create_db_sql}? | ${MYSQL_CMD}?????????????????????????#创建数据库


if [ $? -ne 0 ]????????????????????????????????????????????????????????????????????????????????#判断是否创建成功


then


echo "create databases ${DBNAME} failed ..."


exit 1


fi


echo "create table ${TABLENAME}"


create_table_sql="create table ${TABLENAME}(


name char(6) NOT NULL,


id int default 0


)ENGINE=MyISAM DEFAULT CHARSET=latin1"


echo ${create_table_sql} | ${MYSQL_CMD} ${DBNAME}????????? #在给定的DB上,创建表


if [ $? -ne 0 ]??????????????????????????????????????????????????????????????????????????????????????????????? #判断是否创建成功


then


echo "create? table ${DBNAME}.${TABLENAME}? fail ..."


fi


from:http://blog.163.com/xychenbaihu@yeah/blog/static/132229655201141142057473/



友情链接: