Using Database-Related SHOW Statements : Show « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Show

Using Database-Related SHOW Statements

        
mysql>
SHOW CREATE DATABASE <database name>
mysql>
mysql> SHOW CREATE DATABASE mysql;
+----------+------------------------------------------------------------------+
| Database | Create Database                                                  |
+----------+------------------------------------------------------------------+
| mysql    | CREATE DATABASE `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
    
    
    
    
  

Related examples in the same category