mysql插入表格数据

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

-- 错误示例
INSERT INTO employees (id, name, age) VALUES ('1', 'John Doe', '30');

-- 正确示例
INSERT INTO employees (id, name, age) VALUES (1, 'John Doe', 30);

-- 使用INSERT IGNORE
INSERT IGNORE INTO employees (id, name, age) VALUES (1, 'John Doe', 30);

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO employees (id, name, age) 
VALUES (1, 'John Doe', 30) 
ON DUPLICATE KEY UPDATE name='John Doe', age=30;

-- 确保外键值存在
INSERT INTO departments (id, name) VALUES (1, 'Engineering');
INSERT INTO employees (id, name, age, department_id) VALUES (1, 'John Doe', 30, 1);