How are metadata keys and surrogate handled in MySQL

Question

How are metadata keys and surrogate handled in MySQL?

Answer 1

MySQL employs integer data types combined through the property AUTO_INCREMENT to make surrogate keys. This makes a sequence which starts at one (1) and increases by one (1) for each and every new record. MySql maintain its metadata in a database named mysql. For illustration, this database sustains two tables named user and db.