mysql表格添加数据

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

INSERT INTO `users` (`username`, `email`) VALUES
('jane_doe', 'jane@example.com'),
('jim_smith', 'jim@example.com');

INSERT INTO `user_profiles` (`user_id`, `profile`)
SELECT `id`, 'default profile' FROM `users` WHERE `username` = 'john_doe';

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

INSERT INTO `users` (`username`, `email`) VALUES
('user1', 'user1@example.com'),
('user2', 'user2@example.com'),
...
('user1000', 'user1000@example.com');

START TRANSACTION;
INSERT INTO `users` (...) VALUES (...);
...
INSERT INTO `users` (...) VALUES (...);
COMMIT;