怎么向mysql表中添加数据

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

-- 单行插入
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),
       ('jim_smith', 'jim@example.com', 40);

-- 子查询插入
INSERT INTO user_profiles (user_id, bio)
SELECT id, 'Some bio text'
FROM users
WHERE age > 30;

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

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO users (username, email, age)
VALUES ('john_doe', 'john@example.com', 30)
ON DUPLICATE KEY UPDATE age = 30;

-- 错误示例
INSERT INTO users (username, email, age)
VALUES ('john_doe', 'john@example.com', '30'); -- age应为整数类型

-- 正确示例
INSERT INTO users (username, email, age)
VALUES ('john_doe', 'john@example.com', 30);

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