Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

load data inserts returns into fields!?!

Status
Not open for further replies.

hinchdog

Programmer
Feb 14, 2001
380
US
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!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top