#!/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
简单数据库及表创建shell脚本
最新推荐文章于 2024-07-01 14:44:12 发布