i wanna fill out a column named employee_id from another table by using select below is my query
INSERT INTO information (employee_id)
VALUES (SELECT employee_id FROM employee)
with the above query I am getting an error :
MySQL said: Documentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
near ‘SELECT employee_id FROM employee)’ at line 3**
>Solution :
try like this:
INSERT INTO information (employee_id)
SELECT employee_id FROM employee;