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

2 Answers
7551 Views
SigmaTree, I also Faced
E-Mail Answers

Answer Posted / navaneethakrishnan

DESCRIBE TAB_NAME;

DESC TAB_NAME;

Is This Answer Correct ?

20 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to return query output in xml format?

1076

How many sql ddl commands are supported by 'mysql'?

1182

How to execute mysql query in php?

963

How do I show users in mysql?

1115

Is mysql free for enterprise?

949

How do I change directories in mysql?

945

Can mongodb replace mysql?

978

How do I rename a table in mysql workbench?

1025

Is mysql a nosql database?

1205

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

1014

How to create a test table in your mysql server?

1096

What is the difference between a database and a table?

1048

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

920

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

933

Why mongodb is faster than mysql?

913