What are the other commands to know the structure of table
using MySQL commands except explain command?

Answers were Sorted based on User's Feedback



What are the other commands to know the structure of table using MySQL commands except explain com..

Answer / navaneethakrishnan

DESCRIBE TAB_NAME;

DESC TAB_NAME;

Is This Answer Correct ?    20 Yes 0 No

What are the other commands to know the structure of table using MySQL commands except explain com..

Answer / lekhraj deshmukh

show create table tbl_name;


eg:- show create table tbl_data;

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More MySQL Interview Questions

How would concatenate strings in mysql?

0 Answers  


What is longblob?

0 Answers  


How is mysql database stored?

0 Answers  


How can you see all indexes defined for a table?

0 Answers  


how to find 2nd highest salary in random database salary of employer.....

4 Answers  


Where is the mysql config file?

0 Answers  


How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

0 Answers  


What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.

6 Answers  


What is delimiter $$?

0 Answers  


How many rows can a mysql table hold?

0 Answers  


Is mysql free software?

0 Answers  


How do I view a mysql database?

0 Answers  


Categories