what about the file size. My file size is 10 mb.
When I dump them all with LOAD DATA INFILE I only get first 9800 raws which is size of 2.9 mb. Is there a limit for file size? Where can I increase it? Regards.. ----- Original Message ----- From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "Ferhat BINGOL" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Saturday, November 20, 2004 10:41 PM Subject: Re: LOAD DATA INFILE question... > You can load the file to an intermediate table and then complete your > process using > INSERT INTO targetTable > SELECT col_1, col_5, col_28, col_71 > FROM intermediateTABLE > > > Ferhat BINGOL wrote: > > >Hi, > > > >I have a 72 fields data txt file and I was inserting all data previously > >but now I need only some of them to dump into the table. > > > >I would like to select only 4 fields which are the 1st, 5th,28th and > >71st fields. > > > >Is there a statement to do that. > > > >I have read http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html but could > >not find it... > > > >Thanks... > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
