select * from information_schema.tables where TABLE_SCHEMA='数据库名称'
通过pymysql执行该语句后,最终的结果为元祖类型,其中每个元素是一个数据表的信息,单条信息也是元组类型,其中下标2、-1的分别为数据表的名称、注释。
示例代码:
database_name = "test"
db = pymysql.connect(host='127.0.0.1',
user='root',
password='password',
database=database_name,
port=3306)
sql_str = "select * from information_schema.tables where TABLE_SCHEMA='%s'" % database_name
cursor2 = db.cursor()
cursor2.execute(sql_str)
results = cursor2.fetchall()
cursor2.close()
ddd_list = []
for i in results:
cc = "%s(%s)" % (i[2],i[-1])
ddd_list.append(cc)
cursor2.close()
db.close()