Re: Checking if database has been setup
| From: | Don Read | Date: | Sat, 07 Feb 2004 19:29:42 +0000 |
| Subject: | Re: Checking if database has been setup | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177106@lists.php.net to get a copy of this message | ||
On 07-Feb-2004 Ryan A wrote:
<snip>
> but how do i check if the database/tables have
> been setup?
>
SHOW DATABASES LIKE 'mydb';
SHOW TABLES FROM mydb LIKE 'mytable';
Check if a table exists:
SELECT 1 FROM mydb.mytable LIMIT 1;
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.