Hi,
What MySQL property is used to create a surrogate key in MySQL?
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Prabhu RajaPosted Jan 11, 2012, 11:46 AM
Arjun PanwarPosted Jan 12, 2012, 5:58 PM
Satyapriya NayakPosted Jan 11, 2012, 11:24 AM
A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data.A surrogate key is frequently a sequential number (e.g. a Sybase or SQL Server "identity column", a PostgreSQL
serial, an OracleSEQUENCEor a column defined withAUTO_INCREMENTin MySQL) but doesn't have to be. Having the key independent of all other columns insulates the database relationships from changes in data values or database design (making the database more agile) and guarantees uniqueness.Please refer the below link
http://blog.mclaughlinsoftware.com/2009/05/16/surrogate-keys-uses/
Thanks