mysql insert语句into

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

INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

INSERT INTO users (name, email) VALUES 
('Jane Doe', 'jane@example.com'),
('Jim Smith', 'jim@example.com');

INSERT INTO users (name, email)
SELECT name, email FROM temp_users;

INSERT IGNORE INTO users (id, name, email) VALUES (1, 'John Doe', 'john@example.com');

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

INSERT INTO users (id, name, age) VALUES (1, 'John Doe', CAST('30' AS SIGNED));

INSERT INTO users (name, email) VALUES 
('Jane Doe', 'jane@example.com'),
('Jim Smith', 'jim@example.com'),
...
('Alice Johnson', 'alice@example.com');

LOAD DATA INFILE 'users.csv' INTO TABLE users
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;