Wednesday 27th February 2008Select Insert Statement
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;
thanks for this sample way
March 10th, 2008 at 8:23 am