i used a "load data local infile..." statment using the defaults to load a text file into mysql database. the text file looked as such...
column1 \t value1 \n
column2 \t value2 \n
ect...
(\t represents tab, \n return)
the data went in fine, but i can see that the reurn was inserted into the second field value (it looks like a square thingy). why does this happen and how do i correct it?
thanks!!
column1 \t value1 \n
column2 \t value2 \n
ect...
(\t represents tab, \n return)
the data went in fine, but i can see that the reurn was inserted into the second field value (it looks like a square thingy). why does this happen and how do i correct it?
thanks!!