I want to load specific columns into a new table.
recno, name, phone, active
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!