MySQL Forums
Forum List  »  MySQL Workbench

Multiple Value Reference
Posted by: Double Thumber
Date: July 15, 2008 08:52AM


I have a database that stores a location and its city - i.e.:

ThisPlace Sometown

I want to be able to better organize the data to allow for entries in the table to have multiple cities associated with them without entering a new record, i.e.:

ThisPlace Sometown
ThisPlace Thistown
ThisPlace Othertown
ThisPlace Somewhere

I want to be able to display all the names in the table without showing duplicates because cities are different. I'm looking for a way (possibly with another "cities" table) to store the cities and then reference them in this table. Thanks!

Options: ReplyQuote

Written By
Multiple Value Reference
July 15, 2008 08:52AM

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.