That depends.... It could be as simple as "create table table2 as select * from table1" or you might need to query your values from table1, possibly do some data transformation, and then insert it into table2. If doing the latter, a simple FOR loop combined with capturing your selections from table1 into variables that you then use in your insert statement when inserting into table2 is a good idea.
--- In [email protected], "Brian E Boothe" <[EMAIL PROTECTED]> wrote: > > > How do I move data from one table to another thru a link in mysql and php > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.409 / Virus Database: 268.13.28/518 - Release Date: 11/4/2006 >
