MySQL命令操作（Linux平台）

Linux shell 批量创建数据库/表

Shell 脚本如下：

# create database and table
HOST='localhost'
PORT='3306'
USER='root'
PWD=''
DBNAME='top123'
TABLENAME='gametop800'

mysql_login=''
mysql_create_db=''
mysql_create_table=''


function mysql_create(){
    echo "login mysql $HOST:$PORT ..."
    mysql_login="sudo mysql -h $HOST -P $PORT -u $USER"  # mysql -h host -P port -u root -p pwd
    echo | ${mysql_login}
    if [ $? -ne 0 ]; then
        echo "login mysql ${HOST}:${PORT} failed.."
        exit 1
    fi

    echo "create database $DBNAME ..."
    mysql_create_db="create database if not exists $DBNAME"
    echo ${mysql_create_db} | ${mysql_login}
    if [ $? -ne 0 ]; then
        echo "create db ${DBNAME} failed.."
        exit 1
    fi

    echo "create table $TABLENAME ..."
    mysql_create_table="create table $TABLENAME(
        id char(50) not null,
        top int,
        name char(100),
        category char(50),
        rating float,
        ratingcount char(20),
        download char(30),
        price char(20),
        publishdate char(20),
        version char(40),
        filesize char(40),
        requireandroid char(40),
        contentrating char(40),
        country char(10),
        dtime datetime not null,
        primary key(id, dtime)
    )"

    echo ${mysql_create_table} | ${mysql_login} ${DBNAME} 
    if [ $? -ne 0 ]; then
        echo "create table ${TABLENAME} fail..."
        exit 1
    fi

    echo "create table ${TABLENAME} success!"
}

执行脚本后，结果如下：