mysql 如何插入信息数值

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

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

-- 错误示例
INSERT INTO users (id, name, age) VALUES (1, 'Alice', 'twenty');

-- 正确示例
INSERT INTO users (id, name, age) VALUES (1, 'Alice', 20);

-- 使用INSERT IGNORE
INSERT IGNORE INTO users (id, name, age) VALUES (1, 'Alice', 20);

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO users (id, name, age) VALUES (1, 'Alice', 20)
ON DUPLICATE KEY UPDATE name = 'Alice', age = 20;

-- 错误示例
INSERT INTO users (name) VALUES ('This is a very long name that exceeds the maximum length');

-- 正确示例
INSERT INTO users (name) VALUES ('Alice');