> 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/[EMAIL PROTECTED]