What are the other commands to know the structure of a table using mysql commands except explain command?



What are the other commands to know the structure of a table using mysql commands except explain com..

Answer / Surjeet Kumar Jha

To know the structure of a table in MySQL, you can use the DESCRIBE or SHOW COLUMNS FROM command instead of the EXPLAIN command. The DESCRIBE command provides a human-readable description of the table's columns, while SHOW COLUMNS FROM displays more detailed information about each column.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is difference mysql and mysqli?

1 Answers  


What are the types of database engines available in mysql?

1 Answers  


What is difference between mysqli and pdo?

1 Answers  


Can you tell the difference between $message and $$message?

1 Answers  


What is mysql and how it works?

1 Answers  


How do I start mysql?

1 Answers  


What are the drivers in MySQL?

2 Answers  


What is the purpose of mysql database?

1 Answers  


Should I use pdo or mysqli?

1 Answers  


What is the purpose of using a heap table?

1 Answers  


Write a query to stop mysql in unix

1 Answers  


List some mysql advantages and disadvantages?

1 Answers  


Categories