重置数据库(删库重建)
redb.bat
@color 0A
@popd %~dp0redb.py
@python %~dp0redb.py %*
@timeout 2
redb.py
import sys
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="root",
)
mycursor = mydb.cursor()
if len(sys.argv) < 2 :
mycursor.execute('show databases')
rows = mycursor.fetchall()
for row in rows:
print(row[0])
print('请输入数据库名')
exit(1)
dbname = sys.argv[1]
print('即将重建数据库:' + dbname + '\n')
ret = mycursor.execute('DROP DATABASE IF EXISTS ' + dbname)
ret = mycursor.execute('CREATE DATABASE ' + dbname)