根据某些列的值计数进行增行/删行

import pymysql

# 连接到MySQL数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')
cursor = conn.cursor()

# 根据某些列的值进行计数并增行
cursor.execute("SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 100")
result = cursor.fetchall()
for row in result:
    column_name = row[0]
    count = row[1]
    if count > 100:
        for i in range(count - 100):
            cursor.execute("INSERT INTO table_name (column_name) VALUES (%s)", (column_name,))
conn.commit()

# 根据某些列的值进行计数并删行
cursor.execute("SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) < 10")
result = cursor.fetchall()
for row in result:
    column_name = row[0]
    count = row[1]
    if count < 10:
        cursor.execute("DELETE FROM table_name WHERE column_name = %s", (column_name,))
conn.commit()

# 关闭连接
cursor.close()
conn.close()