mysql如何写入数据

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

INSERT INTO users (username, email, age) VALUES
('jane_doe', 'jane@example.com', 25),
('alex_smith', 'alex@example.com', 40);

UPDATE users SET age = 31 WHERE username = 'john_doe';

REPLACE INTO users (username, email, age) VALUES ('john_doe', 'john_new@example.com', 31);

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

SET NAMES utf8mb4;
INSERT INTO users (username, email, age) VALUES ('张三', 'zhangsan@example.com', 28);

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