Insert Into Select Mysql. Insert Into Table From Another Table

November 5, 2023
-

INSERT INTO employees(emp_id, first_name, middle_name, last_name, POSITION, office_id, verification_key)
SELECT emp_id, fname, mname, surname, POSITION, office_id, MD5(CONCAT(RAND('d'), CURRENT_TIMESTAMP, UNIX_TIMESTAMP())) FROM emp_201_pers_info
WHERE separation_status = 'Active';

General