时间:2021-07-01 10:21:17 帮助过:4人阅读
语法说明如下:
‘ ‘
包围。示例1:
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sakila | | sys | | world | +--------------------+ 6 row in set (0.22 sec)
示例2:使用like语句(模糊查询)
mysql> SHOW DATABASES LIKE ‘%test%‘; +--------------------+ | Database (%test%) | +--------------------+ | db_test | +--------------------+ | db_test_db | +--------------------+ | test_db | +--------------------+ 3 row in set (0.03 sec)
MySQL -- 数据库操作(创建、删除、修改、查看、选择)
标签:名称 数据库 set man mysql 模糊 查询 info test