MySQL Forums
Forum List  »  Newbie

Re: Pattern matching problem
Posted by: Ben Wilson
Date: September 07, 2010 03:25PM


This is so incredibly helpful. I've successfully exploded the tickers into a separate table (save for a few tickers that were separated by spaces instead of commas...).

One final, nuisance question then I promise to stop bugging you: how would I go about populating new entries to the respective databases?

Right now I have a form that just dumps items in, and was using a single field with the comma-separated tickers. I've also entered some items via a CSV file exported from excel (which I'm assuming won't work with this setup).

How would I structure the MySQL query to insert the tickers into the separate table while ensuring correspondence with the Articles table?

Thanks again so very, very much.

Options: ReplyQuote

Written By
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
Re: Pattern matching problem
September 07, 2010 03:25PM
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.