inserting NULL value
| From: | Adv. Systems Design | Date: | Fri, 19 Oct 2001 16:15:07 +0000 |
| Subject: | inserting NULL value | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13539@lists.php.net to get a copy of this message | ||
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, and even if I put something into the
first cell of the "null" column, half ways down the
tab delimited file, excel just drops the field...if I
use the word NULL, the value appears in the db as
"NULL" not as "".
...how do you batch load NULL values?
Thanks
Luis
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com