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 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, password) VALUES ('john_d', 'john@example.com', 'password123'); -- 错误：username应为varchar类型

GRANT INSERT ON database_name.users TO 'username'@'localhost';