简单数据库及表创建shell脚本
原创
©著作权归作者所有：来自51CTO博客作者opskumu的原创作品，请联系作者获取转载授权，否则将追究法律责任
- [python] view plaincopyprint?
- #!/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
