pytho通过pymysql模块获取数据表的行数
源码如下:
import pymysql
con = pymysql.connect(host='localhost', port=3306, passwd='123456', user='step',db='sum')
cmd = con.cursor()
cmd.execute("explain select * from sum;")
info = cmd.fetchall()[0][9]
print(info)
con.close()
执行结果:
原创
2021-03-27 00:38:29 ·
1725 阅读 ·
5 评论