Re: regex help with csv sql dump

Just get the data into a temp mysql table and then use only the fields you
need to create another table like this.

create table new_table select field1,field2,field3 from dumped_table

You can also union the data to existing data but make sure all the fields
are the same by selecting the proper ones or renaming them with aliases like
this:

create table new_table
(select field1,field2,field3 from table1
union
select field1,field2,different_name as field3 from table2) as a

Neil

---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Sat Oct 21 18:13:19 2006