sandman

If the tables share the same structure (same number of columns, each matching pair of columns with the same datatype), then the syntax is really simple --

insert
into table2
select *
from table1
If the tables do not share the same structure, then you must name the columns of the table you are inserting into, and provide an expression for each of them in the subselect --

insert
into table2
( col1
, col2
, col3 )
select field3
, ( field7 + field8 ) * 9.37
, 0
from table1

INSERT INTO is great because of this ability to reformat data as part of the insertion process.

Bob Willis

Table to Another ... means we copy one table to a different table but it contains ... copy the table you need to establish the connection with the MySQL ...







________________
Download Microsoft 2010

yasas177

Well there are Several ways,
- Between two not identical Tables
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE _if_any_condition_applying;

- Between two identical Tables
insert into TableName1
Select * from TableName2

nice123

There is much easier way to do it. In fact you can copy the entire database from one server to another with DataPro - dataPro | Database software | Database conversion | Data Migration

__________________
Web Directory
Magellan Affiliate Program

mings

Was the forum designed by yourself? it is so likeable!

yanejarker

well........................m quite confused will tell u later

staceybrown281

In addition, you should do some connection between the tables before doing this syntax.

Thanks

annawu

It is great! I love them very much!

football_tickets

that is so important information for me thanks for the share


_________________
Football Tickets | Arsenal Tickets | Chesela Tickets | Football Blog