我用的是本机的MySQL,目前只有一个数据库db1
新建文件tj.py,内容如下:
import pymysql
conn = pymysql.connect(
host="127.0.0.1...(data_all)
执行输出:
(('information_schema',), ('db1',), ('mysql',), ('performance_schema',), ('sys',))
结果是一个元组...", "mysql", "performance_schema"]
if i[0] not in exclude_list: # 判断不在列表中时
conn.select_db...", "mysql", "performance_schema"]
if i[0] not in exclude_list: # 判断不在列表中时
conn.select_db...': structure,'explain':explain_new})
print(dic)
执行输出:
{'db1': {'name': 'db1', 'table_list': [{'tname