DESCRIBE TAB_NAME; DESC TAB

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

Question Posted / navaneethakrishnan

Answer Posted / navaneethakrishnan

DESCRIBE TAB_NAME;

DESC TAB_NAME;

Is This Answer Correct ?

20 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of MySQL when compared with Oracle?

931

How to returns the columns and column information pertaining to the designated table.

1022

Which storage engine is best in mysql?

952

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2235

What is row?

1084

How to check if value already exists in mysql database in php?

890

How many entries can mysql handle?

1011

How to get a version of mysql?

1044

How do I create a mysql username and password?

901

What is difference between mysql and mysql server?

996

How internally data stores in MyISAM and INNODB table types?

2738

What are the advantages/disadvantages of mysql and php?

962

What is mysql data directory? How to determine the location of the data directory?

941

How do I stop a query in mysql workbench?

943

Is sqlite faster than mysql?

947