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
What is row level locking?
How to Join tables on common columns.
What is mysql and why it is used?
How to write optimized query in mysql?
How many queries can mysql handle?
How do you use auto increment?
How do I check mysql version?
Where is mysql password stored?
What is pragma exception?
How can you calculate the sum of any column of a table?
Can mysql handle big data?
how to add a new column to an existing table?
Who owns mysql database?
Explain the difference between procedure and function in mysql?
How do I change a procedure in mysql?