mysql自动按时间分表

CREATE TABLE logs_20230101 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    message TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE logs_20230102 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    message TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 其他日期的表类似

<?php
$today = date('Ymd');
$tableName = "logs_$today";

$sql = "INSERT INTO $tableName (message) VALUES (?)";
$stmt = $pdo->prepare($sql);
$stmt->execute(['Hello, World!']);
?>

<?php
$startDate = '2023-01-01';
$endDate = '2023-01-31';

$results = [];
for ($date = $startDate; strtotime($date) <= strtotime($endDate); $date = date('Y-m-d', strtotime($date . '+1 day'))) {
    $tableName = "logs_" . date('Ymd', strtotime($date));
    $sql = "SELECT * FROM $tableName WHERE created_at BETWEEN ? AND ?";
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$startDate, $endDate]);
    $results = array_merge($results, $stmt->fetchAll());
}

print_r($results);
?>