Pointers? I need to move data from one table to another

[juronimo]

I need to move data from 2 fields from one table to another. I made a large addition to a PHP app I'm developing and I had to add a few tables in MySQL. To make it work, I'll need to move data from 2 fields in a table with 200 rows. I don't have use of stored procedures since the ISP is using an ancient form of MySQL (version 3.something).

What would be the steps?

I'd assume I would have to do something like

step 1 select from one table

Iterate through the recordset, doing an insert through each iteration

something like that.

[Ivan_]

Have you tried to make it through phpMyAdmin?
You can choose the data, export them, change them, and then import them.

[juronimo]

I figured it out. What I did was I did something like this:

insert into table1 (field1, field2)
select field1, field2 from table2

No problems it worked fine