如何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'),
       ('alice_smith', 'alice@example.com'),
       ('bob_brown', 'bob@example.com');

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

INSERT IGNORE INTO users (id, username) VALUES (1, 'existing_user');

INSERT INTO users (id, username) VALUES (1, 'existing_user')
ON DUPLICATE KEY UPDATE username = 'existing_user_updated';

INSERT INTO users (username, email) VALUES ('john_doe', NULL);

CREATE TABLE users (
    id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;