Mysql copying

[AOVKSA]

hey all,
ok this is my situation

Inside my database: myp_smooth i have the tables of 2 scripts.

Script ones user system is: table name: USERS, with the fields: USER_NAME, USER_ID and PASSWORD

Script two is: Table name: USER with the fields: USERNAME, USERID and PASSWORD

Now
I want to copy the data from USERS (user_name,user_id,password) and dump it to: USER (username,userid,password)

Because my mysql knowledge is limited i dont know how to insert data from a table with different variables then the other.

Helps would be highly appreciated

thanks

[Xnuiem]

Its a manual process.....select from one, insert into the other.

[AOVKSA]

ther are 20,000+ members ... im sure theres some sort of php code or syntax that can do this for me

[Xnuiem]

Not without mapping. A computer can't just know what fields go where unless they were named exactly the same, and even then the field type should be the same as well.

Either way, you have to map the fields one to another, it is the only way. I know TOAD for MySQL has a mapping utility in it, but I have never used that feature, and I havent used TOAD for MySQL either.

This should be VERY easy, just select, return into a while loop, and insert. If you wanted to be very creative, you could use an array to map the fields.

As to having 20K+ users, while that is true, there are not that many active, and I personally have about 15% of the posts, with Stu coming in with another 8% or so. So 2 users, out of the 20K have almost a quarter of the total posts. Most of those users ask a question or two and then never come back. Only a couple of us stick around.

If you try to code this and run into a problem, give a holler.

[AOVKSA]

My 20k+ users was to make a statement. Though i fully understand your comment regarding user activity. I'm going to research on mapping and see what I can come up with. Thanks, God bless people like you and Stu.

[Xnuiem]

Did you ever get a solution?