In article <[EMAIL PROTECTED]>, "Jessica Svensson" <[EMAIL PROTECTED]> writes:
> LOAD DATA and skip columns in text file... > What i have found out is that this is not possible in any existing > version of mysql, correct? > I found a message from Sinisa Milivojevic @ MySQL AB dated 06/29/2000 > while searching on google. > It said "We have entered this on our TODO list one month ago." > So that would be almost exactly 5 years ago... is it really that this > function has not been implemented during these 5 years? If so, then i > guess it could be 5 more years before its impelemented and that i > should maybe look for other solutions. Maybe they didn't implement it yet because there's an easy workaround: create a temporary table including the columns to be skipped, LOAD it, and then use INSERT..SELECT to copy over only the columns you're interested in. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
