show databases and tables in MySQL
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| django_db |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
6 rows in set (0.52 sec)
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_test |
+----------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
| emp_details |
| employee_profile |
+----------------------------+
12 rows in set (0.00 sec)
mysql>
+--------------------+
| Database |
+--------------------+
| information_schema |
| django_db |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
6 rows in set (0.52 sec)
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_test |
+----------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
| emp_details |
| employee_profile |
+----------------------------+
12 rows in set (0.00 sec)
mysql>
Comments
Post a Comment