Hi:
The problem:
I have two tables.
Table One (named "user") which has fields:
name,
email,
user_name
Table Two (named "user2"), which has fields:
user_name
login_name
password
What I need to is Table One to have populated fields.
name,
email,
login_name
password
The problem as I see it, is to search Table Two for "user_name" found
in Table One. Upon finding a match, then transfer "login_name" and
"password" from Table Two into Table One. I have already set up
fields with same names in Table One for this.
Considering that this is a one time fix, I don't want to write a
program for it but rather just to run a SQL query via phpMyAdmin.
I know I could look it up, but I don't want to make a mistake in testing it.
So, if someone would be so kind, please complete the following query for me?
SELECT user_name FROM `user` WHERE ???
Thanks,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
