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 difference between pdo and mysqli?
What is regexp?
How do I import database through command line?
What is a longblob?
What is a blob datatype?
Does adding an index lock a table?
How to get the number of rows selected or affected by a sql statement?
How do you backup a database in mysql?
How do you rename a procedure in mysql?
How to return query output in html format?
How do you use auto increment?
What is the default port for MySQL Server?
What is row level locking?
what are the different tables present in mysql? : Mysql dba
How would you get the current date in mysql?