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]