删除数据表
import pymysql
pymysql.install_as_MySQLdb()
“”“请关注 www.jjddlc.com”""
“”“作者:Pgabc”""
#假定db_wm为stock数据库下的表
def Del_db(db_wm):
#建立数据库连接
db_link = pymysql.connect(host=‘127.0.0.1’, user=‘root’, passwd=‘xxxxxxxxx’, db=‘stock’, charset=‘utf8’)
cursor = db_link.cursor()
query = “drop table {}”.format(db_wm)
cursor.execute(query)
db.commit()
print(‘原{}表已删除’.format(db_wm)
if name==“main”:
db_nm = ‘stock_basic’
Del_db(db_nm)