Re: mysqldump on specific columns only?
- Date: Sun, 9 Mar 2008 22:02:01 -0700
- From: "Rob Wultsch" <wultsch@xxxxxxxxx>
- Subject: Re: mysqldump on specific columns only?
> MySQL does provide LOAD DATA INFILE
> (http://dev.mysql.com/doc/refman/5.0/en/load-data.html), but I was
> hoping to do it through mysqldump instead of SELECT INTO because I
> assumed the performance was faster. If that's not the case, though,
> I'll go ahead and use SELECT INTO OUTFILE and LOAD DATA INFILE. I
> guess most any character is fine as a delimiter, since my fields
> should all just be IDs...
>
> Thanks,
> Waynn
>
OK. Why not just create the new table and SELECT... INSERT . I would
think that would be the fastest solution of all.
--
Rob Wultsch
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx