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 information_schema in mysql?

0 Answers  

What is data in mysql?

0 Answers  

What is max connections in mysql?

0 Answers  

Is mysql a framework?

0 Answers  

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

1 Answers  




what is database white box testing? : Mysql dba

0 Answers  

Can we create table in stored procedure?

0 Answers  

What is the use of pdo?

0 Answers  

What is a storage engine? What are the differences between innodb and myisam engines?

0 Answers  

How to dump one database for backup.

0 Answers  

How to Change a users password from unix shell.

0 Answers  

What is ISAM?

0 Answers  

For more MySQL Interview Questions Click Here
Categories