查看库名:show databases;
模糊查看库名:show databases like '*test*';
查看表名:show tables;
模糊查看表名:show tables like '*aaa*';
show databases;
>>>
admin
default
test
test_a
other
show databases like '*test*';
>>>
test
test_a
---指定数据库再查表名
use test;
show tables;
>>>
customer_id
active_user
sku_info
test
user_info
validate_black_list_data
show tables like '*user*';
>>>
active_user
user_info
show tables like '*black*list*';
>>>validate_black_list_data