簡單資料庫及表建立shell指令碼

#!/bin/bash

USER='root'
PASS='123'

mysql -u $USER -p$PASS <<EOF 2> /dev/null
create database test1;
EOF

[ $? -eq 0 ] && echo "The database Created test1" || echo "The database test1 is already exist"

mysql -u $USE test1 <<EOF 2> /dev/null
create table test1(
ind int,
name varchar(20)
);
EOF

[ $? -eq 0 ] && echo "The table Created test1" || echo "The table test1 is already exist"

mysql -u $USER -p$PASS test1 <<EOF
DELETE FROM test1;
EOF