Copy data from one mysql table to another?
| From: | Bob Stone | Date: | Wed, 28 Mar 2001 20:53:35 +0000 |
| Subject: | Copy data from one mysql table to another? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7945@lists.php.net to get a copy of this message | ||
Dear PHP Helpers,
I cannot find any documentation on how to copy the
data from one mysql table to another, i.e. table1,
columnx to table2, columnx.
Can you recommend a way?
Here is the situation.
I have one table called "phone" with two columns. The
first column is called "key_svt_members," the second
is called "phone."
I have a second table called "svt_members." This table
has 17 columns including "key_svt_members" and
"phone." The phone column in this table is currently
empty.
I wish to copy the data that is in phone, phone into
svt_members.
Can you recommend a method?
Thanks in advance,
Bob Stone
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text