mysql如何insert

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

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

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO users (username, email) 
VALUES ('john_doe', 'john@example.com') 
ON DUPLICATE KEY UPDATE email = 'john@example.com';

-- 错误示例
INSERT INTO users (username, age) VALUES ('john_doe', '30'); -- age列应为整数类型

-- 正确示例
INSERT INTO users (username, age) VALUES ('john_doe', 30);

-- 批量插入
INSERT INTO users (username, email) VALUES 
('john_doe', 'john@example.com'),
('jane_doe', 'jane@example.com'),
('bob_smith', 'bob@example.com');

-- 使用事务
START TRANSACTION;
INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');
INSERT INTO users (username, email) VALUES ('jane_doe', 'jane@example.com');
COMMIT;