...

View Full Version : mysql dump help



ynotlim
03-12-2007, 08:47 PM
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

guelphdad
03-13-2007, 03:41 AM
don't even need that, it is as simple as:



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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum