i wanna fill out a column named employee_id from another table by using select
this is mt quary:
INSERT INTO information (employee_id)
VALUES
(SELECT employee_id FROM employee)
.
.
and this is the eror :
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