mysql如何增加记录

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

INSERT INTO users (username, email)
VALUES ('john_doe', 'john@example.com');

INSERT INTO users (username, email)
VALUES ('jane_doe', 'jane@example.com'),
       ('jim_smith', 'jim@example.com');

INSERT INTO new_table (column1, column2)
SELECT column1, column2 FROM existing_table;

-- 错误示例
INSERT INTO users (id, username)
VALUES (1, 'john_doe'); -- id为1的记录已存在

-- 解决方法：使用INSERT IGNORE或ON DUPLICATE KEY UPDATE
INSERT IGNORE INTO users (id, username)
VALUES (1, 'john_doe'); -- 忽略错误

INSERT INTO users (id, username)
VALUES (1, 'john_doe')
ON DUPLICATE KEY UPDATE username = 'john_doe'; -- 更新已存在的记录

-- 错误示例
INSERT INTO users (username, email)
VALUES ('john_doe', 12345); -- email应为字符串类型

-- 解决方法：确保插入的数据类型与表定义一致
INSERT INTO users (username, email)
VALUES ('john_doe', 'john@example.com');

-- 解决方法：使用批量插入和事务
START TRANSACTION;
INSERT INTO users (username, email)
VALUES ('user1', 'user1@example.com'),
       ('user2', 'user2@example.com'),
       ...
COMMIT;