Re: Pattern matching problem

[Chad Bourque]

Ben,

I know what would be the best for your scenario. And I don't do much bulk loading of data. But, if nothing else, I would think you could load your data the way you would have before and then use the method above to move the data around to its proper place.

Of course, that would be for a one (or few) time data load procedure. If you are referring to adding data on an ongoing manner, as in users adding new data, then it would just be a matter of insert queries. You will also likely make use of the last_insert_id function if you are using auto_increment columns for your primary keys.

HTH,
Chad