mysql增加语句怎么写

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 
('user1', 'user1@example.com'),
('user2', 'user2@example.com'),
...
('user1000', 'user1000@example.com');