
November 7th, 2001, 12:09 PM
|
|
nerd
|
|
Join Date: Nov 2001
Location: NJ
Posts: 101
Time spent in forums: 9 h 30 m 37 sec
Reputation Power: 7
|
|
|
non-escaped characters causing prob with LOAD DATA?
hey all,
i just loaded a text file in a table using:
LOAD DATA LOCAL INFILE "gt.txt" INTO TABLE guitartabs;
and i am unable to SELECT certain columns using format:
SELECT * FROM guitartabs WHERE (artist = "Van Halen");
selecting by auto_increment ID works fine but any text file comes up empty... any ideas?
and in the text file, i am using {tab} for fields and ' for the records. do i need to use \' for any occurance of a ' character (or !@#$%^&*()- characters)?
thanks,
drGiggles
Last edited by drGiggles : November 7th, 2001 at 12:13 PM.
|