How to get a list of columns in an existing table?



How to get a list of columns in an existing table?..

Answer / Saurabh Agarwal

To get a list of columns (schema) for an existing table in MySQL, run the following command: DESCRIBE table_name;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to shut down the server with 'mysqladmin'?

1 Answers  


How can you change the name of any existing table by using the sql statement?

1 Answers  


How do I start and stop mysql server?

1 Answers  


Why MySQL is used?

1 Answers  


how to connect a php script with the mysql database?

1 Answers  


Does mysql automatically index foreign keys?

1 Answers  


Where is mysql used?

1 Answers  


What is the difference between char and varchar data types?

6 Answers  


Is mysql open source?

1 Answers  


What is prepare statement in mysql?

1 Answers  


How database are managed?

1 Answers  


How to use rank function in mysql?

1 Answers  


Categories