mysql 时间分页

-- 示例：基于索引的分页查询
SELECT * FROM logs
WHERE timestamp >= '2023-01-01' AND timestamp < '2023-02-01'
ORDER BY timestamp
LIMIT 100;

-- 示例：使用事务隔离级别
START TRANSACTION;
SELECT * FROM logs
WHERE timestamp >= '2023-01-01' AND timestamp < '2023-02-01'
ORDER BY timestamp
LIMIT 100;
COMMIT;

-- 示例：流式查询（使用Python和MySQL Connector）
import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'raise_on_warnings': True
}

cnx = mysql.connector.connect(**config)
cursor = cnx.cursor(dictionary=True)

query = ("SELECT * FROM logs "
         "WHERE timestamp >= %s AND timestamp < %s "
         "ORDER BY timestamp")

start_date = '2023-01-01'
end_date = '2023-02-01'

cursor.execute(query, (start_date, end_date))

for row in cursor:
    print(row)

cursor.close()
cnx.close()