[TriLUG] mySQL Data Import
mattfrye at gmail.com
Mon May 2 15:24:32 EDT 2005
On 5/2/05, Mark Freeze <mfreeze at gmail.com> wrote:
> I am trying
> to import a tab-delimited data file...The system gives me the error 'Command
> used is not supported in this version of MySQL.'
> What is the next best way to get my 1000 record file imported into a
> MySQL table?
copy the file name to pfs_trans, then run:
mysqlimport --fields-terminated-by='\t' --lines-terminated-by='\r\n' pfs_trans
More information about the TriLUG