preload
Concatenation Tag Cloud
Feb 27

A very simple way of passing data from one table to another is by using the select insert statement in sql.

INSERT INTO table (forename, dayphone, address1, address2, address3, postcode, country, email)
select r.first_name r.phone_number, r.address1, r.address2, r.address3, r.post_code, r.country, r.email from table2 r;

2 Responses to “Select Insert Statement”

  1. ????? Says:

    thanks for this sample way

  2. thanos Says:

    great work!

Leave a Reply

 
 
Please enter the word above into the box below, the word is not case sensitive.
 
If you have trouble reading the word above then click here to load a new word.
Security word: