数据库插入代码

-- 使用INSERT IGNORE
INSERT IGNORE INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...)
ON DUPLICATE KEY UPDATE column1 = value1, column2 = value2;

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (CAST(value1 AS datatype), value2, value3, ...);

GRANT INSERT ON table_name TO user_name;

-- 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100)
);

-- 插入单条记录
INSERT INTO users (name, email)
VALUES ('John Doe', 'john.doe@example.com');

-- 插入多条记录
INSERT INTO users (name, email)
VALUES 
('Jane Smith', 'jane.smith@example.com'),
('Alice Johnson', 'alice.johnson@example.com');