1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / pranab

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

What is meant by mysql database?

1 Answers  

How can you see all indexes defined for a table?

0 Answers  

What is default password for mysql?

0 Answers  

I want to find out all databases starting with ‘test’, I have access to?

0 Answers  

How do I clear a mysql database?

0 Answers  




How will you export tables as an xml file in mysql?

0 Answers  

Where is the mysql config file?

0 Answers  

What is username in mysql?

0 Answers  

How can you handle the –secure-file-priv in mysql?

0 Answers  

Is pdo faster than mysqli?

0 Answers  

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

What are the technical specifications of mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories