How can you see all indexes defined for a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What is mysqli_result?

0 Answers  


Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  


Why we use mongodb instead of mysql?

0 Answers  


How will you export tables as an xml file in mysql?

0 Answers  


Is mysql good for large database?

0 Answers  






How to start mysql server?

0 Answers  


What is regexp?

0 Answers  


What is mysqli_connect_error ()?

0 Answers  


SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,


How to validate email addresses in mysql?

0 Answers  


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

0 Answers  


How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  


Categories