On Apr 14, 2008, at 4:37 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown <[EMAIL PROTECTED]>
wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and then post back here for the MySQL archives.
Sorry, got "sidetracked" with the day job and the pre-wife
nagging me. ;-P
Anyway, as I suspected, you did have literal \t and \n characters.
I wrote a script to fix it, and I'll link you to the updated CSV
file. Run that with the IGNORE 1 ROWS command and you should be set.
Just to complete the archives, This did fix it. Make sure you don't
try and put literal tab values "\t" and new line values "\n" into your
data and it should work just fine! So thank you Dan for your help!
And everyone else as well!
--
</Daniel P. Brown>
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
