mysql数据库写入方法

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

INSERT INTO table_name (column1, column2, column3, ...)
VALUES 
    (value1_1, value1_2, value1_3, ...),
    (value2_1, value2_2, value2_3, ...),
    ...
    (valuen_1, valuen_2, valuen_3, ...);

INSERT INTO table_name (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM another_table
WHERE condition;

-- 解决方法：使用INSERT IGNORE或ON DUPLICATE KEY UPDATE
INSERT INTO table_name (id, column1) VALUES (1, 'value1') ON DUPLICATE KEY UPDATE column1 = 'value1';

-- 解决方法：确保插入的数据类型与表定义一致
INSERT INTO table_name (column1) VALUES (CAST('value1' AS datatype));

-- 解决方法：使用批量插入或调整MySQL配置参数
SET GLOBAL innodb_buffer_pool_size = 2G; -- 调整缓冲区大小