cmd mysql插入date类型数据

INSERT INTO users (username, registration_date) VALUES ('john_doe', '2023-10-05');

INSERT INTO users (username, registration_date) VALUES ('john_doe', STR_TO_DATE('05-10-2023', '%d-%m-%Y'));

-- 错误的示例
INSERT INTO users (username, registration_date) VALUES ('john_doe', '10000-01-01'); -- 会报错

-- 正确的示例
INSERT INTO users (username, registration_date) VALUES ('john_doe', '9999-12-31');

-- 错误的示例
INSERT INTO users (username, registration_date) VALUES ('john_doe', '2023-10-05 14:30:00'); -- 会报错

-- 正确的示例
ALTER TABLE users MODIFY COLUMN registration_date DATETIME;
INSERT INTO users (username, registration_date) VALUES ('john_doe', '2023-10-05 14:30:00');