Couldn't this be possibly done using a sub query?
INSERT INTO employees3 (id,Lastname,Firstname,Title) (SELECT id,Lastname,Firstname,Title FROM employees WHERE Title='manager');
Something like the above. I know that Subquerys have just recently be supported fully in MySQL
;-)
|