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

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

989

What is the use of mysqli_num_rows?

959

What is current version of mysql?

1034

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

What is auto increment in mysql?

1008

what are the different tables present in mysql? : Mysql dba

1069

Why we use mysqli instead of mysql?

1163

what is constraints? Also explain the different types of constraints?

1020

How can I remotely connect to mysql database?

961

How do I show columns in mysql?

971

How to make a column bigger and delete unique from table.

1033

What is mysql community edition?

996

Is mysql easy to learn?

978

What is full text indexing in mysql?

993

How do you create a primary key?

1053