mysql数据库表添加一行

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

INSERT INTO employees (id, name, position)
VALUES (1, 'John Doe', 'Manager');

INSERT INTO employees (id, name, position)
VALUES 
(2, 'Jane Smith', 'Developer'),
(3, 'Mike Johnson', 'Designer');

INSERT INTO new_employees (id, name, position)
SELECT id, name, position FROM old_employees WHERE department = 'Engineering';

INSERT INTO employees (id, name, position)
VALUES (1, 'John Doe', 'Manager')
ON DUPLICATE KEY UPDATE name = 'John Doe', position = 'Manager';

INSERT INTO employees (id, name, position)
VALUES (CAST('1' AS UNSIGNED), 'John Doe', 'Manager');

INSERT INTO departments (id, name) VALUES (1, 'Engineering');
INSERT INTO employees (id, name, position, department_id)
VALUES (1, 'John Doe', 'Manager', 1);