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] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
