mysql中怎么记录总数

SELECT COUNT(*) AS total_count FROM your_table;

CREATE TABLE table_summary (
    table_name VARCHAR(255) NOT NULL,
    total_count INT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (table_name)
);

DELIMITER //
CREATE TRIGGER update_total_count
AFTER INSERT ON your_table
FOR EACH ROW
BEGIN
    UPDATE table_summary SET total_count = total_count + 1 WHERE table_name = 'your_table';
END;
//
CREATE TRIGGER update_total_count_on_delete
AFTER DELETE ON your_table
FOR EACH ROW
BEGIN
    UPDATE table_summary SET total_count = total_count - 1 WHERE table_name = 'your_table';
END;
//
DELIMITER ;

import redis
import pymysql

# 连接到Redis服务器
redis_client = redis.StrictRedis(host='localhost', port=6379, db=0)

# 连接到MySQL数据库
mysql_conn = pymysql.connect(host='localhost', user='your_user', password='your_password', db='your_db')
mysql_cursor = mysql_conn.cursor()

# 查询记录总数
mysql_cursor.execute("SELECT COUNT(*) FROM your_table")
total_count = mysql_cursor.fetchone()[0]

# 将结果存储到Redis中
redis_client.set('your_table_total_count', total_count)

# 关闭数据库连接
mysql_cursor.close()
mysql_conn.close()

total_count = redis_client.get('your_table_total_count')
if total_count is not None:
    print(f"Total count: {int(total_count)}")
else:
    # 如果Redis中没有缓存，则查询数据库并更新缓存
    mysql_cursor.execute("SELECT COUNT(*) FROM your_table")
    total_count = mysql_cursor.fetchone()[0]
    redis_client.set('your_table_total_count', total_count)
    print(f"Total count: {total_count}")