import error into mySQL
| From: | Dave Pollak | Date: | Thu, 25 Oct 2001 18:37:17 +0000 |
| Subject: | import error into mySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13728@lists.php.net to get a copy of this message | ||
Howdy,
New to databases, mySQL, and PHP. In my first PHP/mySQL application I'm
loading data from a flat file exported from a Paradox database. Dates in one
field import as 0000-00-00 though they import properly in other fields. They
appear to be configured alike - dob DATE & date_reg DATE - and the data in
the text file is correct. Loaded data from local infile declaring delimiter
as ',' and field enclosure as '"' (double quote). Also have run some select
queries where field_name is null that do not return any rows yet visual
examination of fields after select * query shows no data. Thoughts?
Dave Pollak