Re: [Fwd: search issue] mysqlimport problem with , inside fields

Scott Hamm wrote: > > Line 48: > > "48", "14.729606", "10.1.1.22", "10.182.167.209", "TCP", "pop3 > > [SYN, > ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460" > Is the line 48 is different than other lines? -- View this message in context: http://www.nabble.com/mysqlimport-problem-with-%2C-

Re: mysqlimport problem with , inside fields

Hey Scott - I dont think you can use , with mysqlimport as a field separator if it is part of the data. use something else - I used the pipe | character... This is what worked for me: C:\>mysqlimport --fields-enclosed-by=""" --fields-terminated-by=| --lines-terminated-by="\r\n" --ignore-lines=1

mysqlimport problem with , inside fields

I've been trying to import fields that contains the comma character ',' inside double quotes '"', with the results following: mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark "c:\documents and set