Python：查询 mysql 的所有表和字段 -> pymysql 演示

最新推荐文章于 2024-09-02 22:38:18 发布

显魄-Simple

最新推荐文章于 2024-09-02 22:38:18 发布

阅读量1.6w

点赞数 6

分类专栏： python

本文链接：https://blog.csdn.net/qq_33811662/article/details/80855430

版权

python 专栏收录该内容

39 篇文章 1 订阅

订阅专栏

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pymysql

# 查询所有字段
def list_col(localhost, username, password, database, tabls_name):
    db = pymysql.connect(localhost, username, password, database, charset="utf8")
    cursor = db.cursor()
    cursor.execute("select * from %s" % tabls_name)
    col_name_list = [tuple[0] for tuple in cursor.description]
    db.close()
    return col_name_list

# 列出所有的表
def list_table(localhost, username, password, database):
    db = pymysql.connect(localhost, username, password, database, charset="utf8")
    cursor = db.cursor()
    cursor.execute("show tables")
    table_list = [tuple[0] for tuple in cursor.fetchall()]
    db.close()
    return table_list


username = "root" # 用户名
password = "root" # 连接密码
localhost = "localhost" # 连接地址
database = "school" # 数据库名
tables = list_table(localhost, username, password, database) # 获取所有表，返回的是一个可迭代对象
print(tables) 

for table in tables:
    col_names = list_col(localhost, username, password, database, table)
    print(col_names) # 输出所有字段名