Mysql method to view database creation information

1. Use the command select database(). From the query results, we can see that we have not entered any database currently. So NULL*/.

+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

2. Use the show tables statement, and the result of the query is the name of the currently used database.

mysql> show tables;
 
+-------------------+
 
| Tables_in_test    |
 
+-------------------+
 
| push_test         |
 
| ship_order_detail |
 
+-------------------+
 
2 rows in set (0.00 sec)

The above is the detailed content of Mysql method to view database creation information. For more information, please follow other related articles on the PHP Chinese website!