update table set column=LEFT(column, LENGTH(column)-1)
Andrea Broerman wrote:
I have successfully loaded data from a comma separated file (CSV) into a table, but the last field in each record appears to have a little square symbol at the end of the text which I assume is either an end of line or new line symbol. Is there a way to get rid of that? How can I run the load data command and not get that symbol stored at the end of the text?
Thanks, Andrea
__________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
