MySQL Forums
Forum List  »  Sybase

Too many key parts specified
Posted by: Aldo Herrera
Date: June 01, 2007 11:11PM


I'm migrating table that have more than 16 key parts, and i cant created it in Mysql. What should i do? As i understand, i have 2 options:

1. Create an id as identity column, making this column the key for the table, and left the real key outside of the key.
2. Create insert and update trigers that will concatenate all the fields of the key in one field wich would be the key for the table.

Which implementation would you recomend? Or if you have other ideas? Which one would be faster to use with heave selects and other operations?

Thankyou in advance!

Options: ReplyQuote

Written By
Too many key parts specified
June 01, 2007 11:11PM
October 09, 2007 07:00AM

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.