List:General Discussion« Previous MessageNext Message »
From:zOrg Date:April 28 1999 1:14pm
Subject:Table entrie transfert
View as plain text  
Using PHP3, I would like to move one entrie of 5 fields with a primary key from a mysql
table to another table
like fo example :

TABLE 1
---------------------------------------------------------------------------------------
login        passwd        email                    id        date
(primary key)
---------------------------------------------------------------------------------------
Bob         dog              bob@bobbycom    563      19990201
Jim          cat               jim@hotmailcom  123       19990302
Billy         mouse         bill@grrrorg           578      19990304
---------------------------------------------------------------------------------------

 |    |     ENTRIE "JIM" TRANSFERED TO     |    |   
\/   \/                                                         \/   \/  

TABLE 2
---------------------------------------------------------------------------------------
login        passwd        email                    id        date
(primary key)
---------------------------------------------------------------------------------------
Jim          cat               jim@hotmailcom  123       19990302
---------------------------------------------------------------------------------------

What is the best way (easiest, fastest...) to do such things with php3 and mysql ?
Is there a mysql functiun to do this ?

Thanx for your help

-zOrg-
zorgy@stripped


Thread
Table entrie transfertzOrg28 Apr
  • Re: Table entrie transfertFred Read28 Apr