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 can you find out the version of the installed mysql?

1237

How triggers can be used in mysql?

951

Explain timestamp?

922

How to change a password for an existing user via mysqladmin?

930

How to run 'mysql' commands from a batch file?

968

What is mysqli_connect_error ()?

970

What is the data type for file in mysql?

923

What is text in mysql?

857

What is a blob datatype?

813

How would concatenate strings in mysql?

946

How to use in conditions?

937

Do you need a license for mysql?

895

What is mysqli_free_result?

849

How to enter boolean values in sql statements?

1065

How you will show all data from a table.

927