mysql如何加入数据

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 new_users (username, email)
SELECT username, email FROM old_users;

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

START TRANSACTION;
INSERT INTO users (username, email) VALUES 
('user1', 'user1@example.com'),
('user2', 'user2@example.com');
COMMIT;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) CHARACTER SET utf8mb4,
    email VARCHAR(255) CHARACTER SET utf8mb4
) DEFAULT CHARSET=utf8mb4;