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

How do I completely remove mysql from windows?

931

What is data types in mysql?

878

What are the indexes in mysql?

976

Is mysql port 3306 tcp or udp?

887

Can python connect to mysql?

964

What is pdo mysql?

892

How does mysql store dates?

894

How do I find users in mysql?

1046

How do I create a stored procedure in mysql?

851

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

846

How can you see all indexes defined for a table?

1079

What are the advantages of a procedure?

884

Is mysql a good database?

910

What is int unsigned?

899

How can you validate emails using a single query?

849