A Z [EMAIL PROTECTED] wrote:
MySQL 4.0.14
Possible to query for existence of a DB. For example
connect to MySQL and run run a command to check if
Database (Test2) existed.
Use SHOW DATABASES command:
SHOW DATABASES LIKE 'Test2';
This works on 4.1.1, not sure if it works on 4.0.14:
show databases like '%backups%'
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 12:33 AM
Subject: If DataBase Exists
MySQL 4.0.14
Possible to query for existence of a DB.