MySQL Forums
Forum List  »  MySQL Workbench

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

Hello,

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


Subject
Views
Written By
Posted
Multiple Value Reference
3748
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.