MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

How can you see all indexes defined for a table?

Indexes are used to find the rows using the column in a quick way.  These are majorly helpful when large data is present in the table. Most MySQL indexes (PRIMARY KEYUNIQUEINDEX and FULLTEXT) are stored in B-trees. Indexes are defined for the table by: 

SHOW INDEX FROM <tablename>;

 




Next 5 interview question(s)

1
How do you login to MySql using Unix shell?
2
What is the difference between primary key and candidate key?
3
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
4
What are the drivers in MySQL?
5
What storage engines are used in MySQL?