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
...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?
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
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]