Situation - I have a data file I want to load, but it has additional data that doesn't fit my table and if possible I don't want to have to change the table structure.
So I look at the docs for LOAD TABLE and there we are - just what I need:
However, what ever I do, I don't seem to be able to have more that one column ignored. If I use filler() more than once I get a duplicate column error.
Is there away of getting columns ignored without hitting the Column names cannot be repeated restriction ?
asked 14 Dec '10, 17:27