RE: Regarding the date values loading into the tables from a text file

2006-01-19 Thread lakshmi.narasimharao
Hi, From the front end I need to use double slashes i.e (\\) to enter one slash (\) into the MySQL database. I.e, if I enter "Gelb\Paha", it stores in the mySQL as "GlebPaha", If I enter "S\\Greeen", it stores as "S\Green" in the database. Is there any way in MySQL so that I can enter any

Re: Regarding the date values loading into the tables from a text file

2006-01-16 Thread SGreen
<[EMAIL PROTECTED]> wrote on 01/16/2006 08:22:00 AM: > > Hi, > >I am trying to load the data from a text file into the table. I > have two datetime datatype fileds in my table. > When I loaded the data into the table using the "Load Data INFILE " > syntax, In the table my date fileds