Hi,
we have a big problem with inserting large amounts of data (2GB) into our MyISAM databank (version 4.0.12).
The dataset is loaded in using LOAD DATA infile 'bla' ignore into table tab fields terminated by ' ' optionally enclosed by '' (int1, int2, int3, date);
The format of the text file is...
int1 int2 int3 'date'
...with white spaces between each field. After loading the data, there seems to be inconsistencies between the text-input data and the data in the mySQL table.
The problem seems to be localized to int3 and date, which shows integers that have 20 appended to the original data. (Ie. if int3 is 15, it would be in the database as 2015) and date is '0000-00-00'.
Any suggestions?
Check the syntax after optionally enclosed, make sure it is
optionally enclosed by '\''
not
optionally enclosed by ''
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
