When I load data into a mysql table from a simple tab
delimeted textfile I prepared in a regular
texteditor (notepad) using the "load data infile"
command there is a newline character at the end of
the text in every last column.
How do I get rid of this newline character or are
there alternative methods of quickly loading
data into a table.
Thanks for your hints and tips.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php