- Home
- Interview Questions
- MySQL
16.
What are CSV tables?
- Those are the special tables, data for which is saved into comma-separated values files. They cannot be indexed.
17.
Explain federated tables.
- Introduced in MySQL 5.0, federated tables allow access to the tables located on other databases on other servers.
18.
What is SERIAL data type in MySQL?
- BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT
19.
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
- It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already.
20.
Explain the difference between BOOL, TINYINT and BIT.
- Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.
|
|
||||||||||||||||||||||||||||
