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
Poss
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';
http://www.mysql.com/doc/en/S
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.
regards
___
Yahoo! Messenger - Communicate instantly..."P
