Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How are surrogate keys and metadata handled in MySQL?

user-image
Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2014/12/29
Emad Mohammed said abdalla
by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company

MySQL uses integer data types combined with the property AUTO_INCREMENT to create surrogate keys. This creates a sequence that starts at one (1) and increases by one (1) for each new record. MySql maintain its metadata in a database named mysql. For example, this database maintains two tables named user and db.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.