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

Answers were Sorted based on User's Feedback



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

Answer / navaneethakrishnan

DESCRIBE TAB_NAME;

DESC TAB_NAME;

Is This Answer Correct ?    20 Yes 0 No

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

Answer / lekhraj deshmukh

show create table tbl_name;


eg:- show create table tbl_data;

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More MySQL Interview Questions

How we can get the current date in mysql?

0 Answers  


What is bdb (berkeleydb)?

0 Answers  


What is the latest version of mysql?

0 Answers  


Can you tell a way to know the number of days between the two given dates in php?

0 Answers  


What is a storage engine? What are the differences between innodb and myisam engines?

0 Answers  


How do you say mysql?

0 Answers  


What are some good ideas regarding user security in MySQL?

2 Answers  


Explain % and _ inside like statement?

0 Answers  


Is mysql workbench a dbms?

0 Answers  


What is federated tables in mysql?

0 Answers  


How to enable or disable a row of a table using MySQL in struts?

0 Answers  


How does mysql store data?

0 Answers  


Categories