MySQL Forums
Forum List  »  Newbie

Re: Pattern matching problem
Posted by: Chad Bourque
Date: September 07, 2010 04:39PM

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

Options: ReplyQuote


Subject
Written By
Posted
September 02, 2010 01:11PM
September 02, 2010 02:33PM
September 02, 2010 02:46PM
September 02, 2010 03:10PM
September 02, 2010 04:24PM
September 02, 2010 08:55PM
September 03, 2010 08:37AM
September 07, 2010 03:25PM
Re: Pattern matching problem
September 07, 2010 04:39PM
September 07, 2010 06:13PM
September 07, 2010 07:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.