要遍历数据库表的列,并打印其中记录数量,可以使用以下步骤进行解决:
mysql-connector-python
库连接数据库。import mysql.connector
# 连接数据库
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
DESCRIBE
语句获取表的列信息。# 获取表列信息
mycursor = mydb.cursor()
mycursor.execute("DESCRIBE yourtable")
columns = mycursor.fetchall()
SELECT COUNT(*)
语句获取记录数量,并打印出来。# 遍历列并打印记录数量
for column in columns:
column_name = column[0]
mycursor.execute(f"SELECT COUNT(*) FROM yourtable WHERE {column_name} IS NOT NULL")
record_count = mycursor.fetchone()[0]
print(f"Column '{column_name}': {record_count} records")
完整的示例代码如下:
import mysql.connector
# 连接数据库
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
# 获取表列信息
mycursor = mydb.cursor()
mycursor.execute("DESCRIBE yourtable")
columns = mycursor.fetchall()
# 遍历列并打印记录数量
for column in columns:
column_name = column[0]
mycursor.execute(f"SELECT COUNT(*) FROM yourtable WHERE {column_name} IS NOT NULL")
record_count = mycursor.fetchone()[0]
print(f"Column '{column_name}': {record_count} records")
请注意,这只是一个示例代码,需要根据实际情况进行相应的修改和适配。