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

Does mysql use t sql?

964

How can we optimize stored procedure?

948

Does mysql support nosql?

909

How to define numeric 9(3) in db2 table without decimal point??

2846

What is the size of mysql database?

933

Does mysql need a server?

921

How do you stop an access query?

905

Can varchar be primary key?

916

Can we store files in mysql?

908

Which is faster mongodb or mysql?

890

What is blob in mysql?

1010

What is horizontally scalable?

978

How many rows we can insert in a mysql table?

957

How big is a blob mysql?

888

Which statement is used in a select query for partial matching?

1187