Null values are displayed as NULL. NULL is NOT the same as "".
"" is an empty string. NULL means no value is assigned.
-Original Message-
From: Adv. Systems Design [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 11:15 AM
To: PHP List
Subject: [PHP-DB]
Hello *
I am trying to batch load data into MySQL 3.23.39 from
data that I am preparing using MS Excel, converting to
tab-delimited txt file and uploading using
phpMyAdmin...
...the problem is in trying to load the NULL value for
some columns...if I leave the column empty it just
gets truncated,