[EMAIL PROTECTED] wrote:
In MYSQL documentation the following line is
Some cases are not supported by LOAD DATA INFILE: 1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty) and BLOB or TEXT columns
I defined a column in a table as type TEXT. I then loaded values using LOAD DATA INFILE into the table. Since I was able to load data for a TEXT column, what does the above statement mean..
Well, when loading a single column table, there are no field separators. The line terminator is sufficient.
Try defining a table with more than one field, and see what happens.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]