mysql 新增一行数据

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

INSERT INTO users (username, email, password) VALUES 
('jane_doe', 'jane@example.com', 'password456'),
('alex_smith', 'alex@example.com', 'password789');

INSERT INTO user_profiles (user_id, bio)
SELECT id, 'Some bio text' FROM users WHERE username = 'john_doe';

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

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

INSERT INTO users (username, email, password) 
VALUES ('john_doe', CAST('john@example.com' AS CHAR(255)), 'password123');