show create table tbl_name; eg:- show create table tbl

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

Question Posted / lekhraj deshmukh

Answer Posted / lekhraj deshmukh

show create table tbl_name;

eg:- show create table tbl_data;

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I download mysql on my laptop?

823

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

874

What are the difference between and myisam and innodb?

950

what is the procedure to configure the application of mysql?

959

In mysql, what is the default storage engine?

926

Is mariadb better than mysql?

983

How MySQL Optimizes DISTINCT?

1039

What is the difference between float and double?

1045

Is primary key auto increment?

904

How we can get distinct columns values in mysql?

1011

What does mysql_query return?

956

How to delete a database from mysql server.

981

How can you calculate the sum of any column of a table?

984

How many triggers are possible in mysql?

898

How to rename an existing table in mysql?

964