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 number

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

2006-01-16 Thread lakshmi.narasimharao
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 values are loaded as -00-00 00:00:00. The datetime value in the

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 values