mysql 时间排序问题

-- 设置时区
SET time_zone = '+8:00';

-- 确保时间格式统一
ALTER TABLE your_table MODIFY your_datetime_column DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

-- 排序
SELECT * FROM your_table ORDER BY your_datetime_column DESC;

-- 使用COALESCE函数处理空值
SELECT * FROM your_table ORDER BY COALESCE(your_datetime_column, '0000-00-00 00:00:00') DESC;

-- 统一时间格式
UPDATE your_table SET your_datetime_column = STR_TO_DATE(your_datetime_column, '%Y-%m-%d %H:%i:%s');

-- 排序
SELECT * FROM your_table ORDER BY your_datetime_column DESC;

-- 创建表
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(255),
    event_time DATETIME
);

-- 插入数据
INSERT INTO events (event_name, event_time) VALUES
('Event A', '2023-04-01 10:00:00'),
('Event B', '2023-04-01 09:30:00'),
('Event C', '2023-04-02 11:00:00');

-- 按时间降序排序
SELECT * FROM events ORDER BY event_time DESC;