Move fielddata to a new database?

Beridox

Hi!

I have 2 tables and want to move some field’s information to a new database.

Table 1 has 62 fields and there are 5 that I want the data from (uid uname email user_regdate user_posts).

Table 2 has 63 fields and the 5 fields have other names (user_id username user_email user_regdate user_posts).

I need only this 5 field’s info (wants to clean out the other info).

Its app. 1700 lines (users) that need to be moved.

Both tables are on the same computer and I run phpMyAdmin 2.5.6 (MySQL 4.0.18-nt).

How should i do this the easy way?

/Anneli

bastien

insert into tableName (select field1,field2...field5 from other_table)

as long as the five fields are in the new table and the data types are the same

Beridox

But table 2 is in another database, how shall i write that?
And the fieldnames are not the same.

/Anneli

Originally posted by bastien
insert into tableName (select field1,field2...field5 from other_table)

as long as the five fields are in the new table and the data types are the same

bastien

Names don't need to be the same. The structure needs to be the same in the destination table and the select tables....

In looking at your post again, I would drop the extra columns that you no longer need (copy the table first, then drop the columns from the copy)....

Mysql supports the DataBaseName.tableName.FieldName construct so you can use that in the sql to get the data

Another option is just to export the data from those columns with phpmyadmin or some other gui tool and then import that data into the other database

hth