Hi,
I need to migrate data from an old table to a new one. My plan is to do a dump but my trouble is that I only want to keep some of the fields. Eg:
The old table has these fields;
date, title, date_made, timestamp, body.
The new table has these fields;
date, title, body.
I need to dump only the data I want into the new table. Any idea on how to do a selective dump, oh and I'm talking mysql here.
Thanks for your time,
Billy
I need to migrate data from an old table to a new one. My plan is to do a dump but my trouble is that I only want to keep some of the fields. Eg:
The old table has these fields;
date, title, date_made, timestamp, body.
The new table has these fields;
date, title, body.
I need to dump only the data I want into the new table. Any idea on how to do a selective dump, oh and I'm talking mysql here.
Thanks for your time,
Billy