4 messages in com.mysql.lists.mysqlRe: mysqlimport - parse error
FromSent OnAttachments
David Button06 Sep 1999 08:49 
sin...@cytanet.com.cy06 Sep 1999 09:03 
David Button07 Sep 1999 04:28 
Bob Duncan07 Sep 1999 07:11 
Subject:Re: mysqlimport - parse error
From:sin...@cytanet.com.cy (sin@cytanet.com.cy)
Date:09/06/1999 09:03:56 AM
List:com.mysql.lists.mysql

David Button writes:

Hi

I'm going mad trying to get mysqlimport to work. I keep getting 'error 1064 parse error'

I am using the command at the mysql command line via telnet.

The text file with the comma delimited data is the same name as the table I'm trying to import into. I have tried every option I can think of, here is my latest effort:

mysqlimport --fields-enclosed-by='' --fields-terminated-by=, proddb home/html_files/test.txt

The text file is on the same server as mysql and I'm using relative address as supplied by my hosting company

Any ideas (please) David Webguides Online Ltd

HI!

Try using --fields-enclosed-by='\''

Sinisa

+----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mys@tcx.se | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@cytanet.com.cy| | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+