mysql数据库插入时间

CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    order_date DATETIME,
    customer_name VARCHAR(100)
);

INSERT INTO orders (order_date, customer_name) VALUES (NOW(), 'John Doe');

SET time_zone = '+08:00'; -- 设置时区为东八区
INSERT INTO orders (order_date, customer_name) VALUES (NOW(), 'John Doe');

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'raise_on_warnings': True,
    'connection_timeout': 5,
    'charset': 'utf8mb4',
    'collation': 'utf8mb4_unicode_ci',
    'time_zone': '+08:00'
}

cnx = mysql.connector.connect(**config)

INSERT INTO orders (order_date, customer_name) VALUES (DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'), 'John Doe');