What are the other commands to know the structure of table
using MySQL commands except explain command?
Answer Posted / lekhraj deshmukh
show create table tbl_name;
eg:- show create table tbl_data;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Can we use mysql and mysqli together?
Is mysql owned by oracle?
What is triggers?
How do I truncate all tables in mysql?
Why does mysql have so many connections?
How do you kill a long running query in mysql?
How to filter data from a mysql database table with php?
What does the file with the extension: frm, myd, and myi contain?
How do I select a database in mysql workbench?
What is session variable in mysql?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
What are the differences between mysql vs sql server?
How to present a past time in hours, minutes and seconds?
What is foreign key in mysql?
Write a query to select all teams that won either 1, 3, 5 or 7 games.