原文:https://www.oschina.net/code/snippet_2310702_48414
原文1:https://www.runoob.com/python/python-mysql.html
安装MySQL-python
pip install MySQL-python
dome1
def db_mange(db_bank):
conn = None
try:
# 打开数据库连接
conn = MySQLdb.connect('localhost', 'root', '123456', db_bank)
# 获取操作游标
cursor = conn.cursor()
# 选择连接的数据库
# conn.select_db(db_bank)
sq1 = "select table_name from information_schema.tables where table_schema='%s' and table_type='base table'" % db_bank
# 查看数据库中所有表的名称
cursor.execute(sq1)
# 提交事务
conn.commit()
results = cursor.fetchall()
# 关闭操作游标
cursor.close()
return results
except MySQLdb.Error, msg:
print "MySQL Error %d: %s" % (msg.args[0], msg.args[1])
finally:
if conn:
# 关闭数据库连接
conn.close()