How can I see mysql database?



How can I see mysql database?..

Answer / Rohit Vaish

To see the structure of a MySQL database, you can use the SHOW CREATE DATABASE command. Here's an example:

```sql
SHOW CREATE DATABASE <database_name>;
```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is insert query in mysql?

1 Answers  


can you elaborate on blob and text in mysql? : Mysql dba

1 Answers  


Can a table have multiple primary keys?

1 Answers  


how to delete duplicate rows in sql server 2005?

2 Answers   EWIT, Reliance,


What is the maximum length of a table name, database name, and fieldname in MySQL?

3 Answers   Accenture, Pioneer, TISL,


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  


Where is mysql installed on linux?

1 Answers  


What is pdo in php mysql?

1 Answers  


What is the purpose of -> in the mysql terminal?

1 Answers  


What is a data directory?

1 Answers  


Can we store pdf files in mysql?

1 Answers  


What tools available for managing mysql server?

1 Answers  


Categories