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'),
('alex_smith', 'alex@example.com');

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

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

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

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

-- 创建用户表
CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL
);

-- 插入单条记录
INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');

-- 插入多条记录
INSERT INTO users (username, email) VALUES 
('jane_doe', 'jane@example.com'),
('alex_smith', 'alex@example.com');