Français English Español Italiano Português
User Login    
 + User Registration
Connexion

Select Insert Statement


Author : lotsofcode | Lots of Code
Date : 2008-02-27T14:32:20+01:00
Views : 5

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;



URL : http://community.xoofoo.org/modules/actus_webmaster/view.article.php/9
Trackback : http://community.xoofoo.org/modules/actus_webmaster/trackback.php/9

The comments are owned by the poster. We aren't responsible for their content.
Poster Thread