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

Can we use mysql and mysqli together?

989

Is mysql owned by oracle?

1017

What is triggers?

959

How do I truncate all tables in mysql?

984

Why does mysql have so many connections?

890

How do you kill a long running query in mysql?

895

How to filter data from a mysql database table with php?

898

What does the file with the extension: frm, myd, and myi contain?

923

How do I select a database in mysql workbench?

1013

What is session variable in mysql?

978

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

2005

What are the differences between mysql vs sql server?

1053

How to present a past time in hours, minutes and seconds?

1048

What is foreign key in mysql?

1035

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1361