Insert from 1 table to another

[kschuster]

What is the correct sql to insert fields from one table to another?

MySQL...

Is the following close?

insert into requests (requests.visitorid,requests.type,
requests.appt_time,requests.appt_date)

VALUES
( visitors.id,
visitors.type,
visitors.appt_time,
visitors.appt_date )

I'm in the process of splitting our the tables

[[deleted]]

insert into requests (visitorid, type, appt_time, appt_date) select visitors.id, visitors.type, visitors.appt_time, visitors.appt_date from visitors

that should do it for you...

http://www.mysql.com/doc/en/INSERT_SELECT.html