SELECt SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERe SCHEMA_NAME = 'DBName'
如果您只想知道数据库是否存在,以免在尝试创建数据库时出错,只需使用(From
here):
CREATE DATAbase IF NOT EXISTS DBName;

SELECt SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERe SCHEMA_NAME = 'DBName'
如果您只想知道数据库是否存在,以免在尝试创建数据库时出错,只需使用(From
here):
CREATE DATAbase IF NOT EXISTS DBName;