RE: [PHP-DB] inserting NULL value

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:asd_2000@yahoo.com] Sent: Friday, October 19, 2001 11:15 AM To: PHP List Subject: [PHP-DB] inserting NULL value 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net