Using INSERT SELECT to copy & populate one table from another.
Using INSERT SELECT to copy & populate one table from another.
Open the destination database - where you want the new records to be:
Execute the following type of example to insert records from your
INSERT INTO current_db_name.dest_table(id, user_id, billed, billable, invoice_id, client_id, client_projects_id, time_in, time_out, ttl_hrs, subj, descr, notes, created )
SELECT `origin_table`.`id`,
`origin_table`.`author` as 'user_id',
`origin_table`.`billed`,
`origin_table`.`billable`,
`origin_table`.`invoice_id`,
`origin_table`.`cust_id` as 'client_id',
`origin_table`.`proj_id` as 'client_projects_id',
`origin_table`.`time_in`,
`origin_table`.`time_out`,
`origin_table`.`ttl_hrs`,
`origin_table`.`subj`,
`origin_table`.`descr`,
`origin_table`.`notes`,
`origin_table`.`tstamp` as 'created'
FROM `origin_database`.`origin_table`;