mysql保存时分秒

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

-- 插入数据
INSERT INTO events (event_name, start_time) VALUES ('Meeting', '14:30:00');

-- 查询数据
SELECT event_name, start_time FROM events;

INSERT INTO events (event_name, start_time) VALUES ('Meeting', '14:30:00');

-- 错误的插入
INSERT INTO events (event_name, start_time) VALUES ('Meeting', '999:99:99'); -- 会报错

-- 正确的插入
INSERT INTO events (event_name, start_time) VALUES ('Meeting', '14:30:00');

-- 创建表时设置时区
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(255),
    start_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 插入数据
INSERT INTO events (event_name, start_time) VALUES ('Meeting', '2023-10-01 14:30:00');