mysql dump help

Hello,

I want to load specific columns into a new table.

current_table:
recno, name, phone, active

new_table:
recno, address, active

I want to load:
select recno, active from current_table where active=1

into the new table.

do i use mysql dump? how do I put the query into the mysql dmp?

thanks in advance!
Tony

don't even need that, it is as simple as:


INSERT INTO new_table
select recno, active from current_table where active=1