mysql 怎么添加数据

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

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

INSERT INTO users (username, email)
VALUES ('JaneDoe', 'jane@example.com'),
       ('MikeSmith', 'mike@example.com');

-- INSERT IGNORE
INSERT IGNORE INTO users (username, email) VALUES ('JohnDoe', 'john@example.com');

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

-- 错误的插入
INSERT INTO users (username, age) VALUES ('JohnDoe', 'twenty'); -- age 应为整数类型

-- 正确的插入
INSERT INTO users (username, age) VALUES ('JohnDoe', 20);

-- 授予权限
GRANT INSERT ON database_name.users TO 'username'@'host';