Re: [PHP] Checking if database has been setup

2004-02-07 Thread Don Read
On 07-Feb-2004 Ryan A wrote: > 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 [EMAIL PR

Re: [PHP] Checking if database has been setup

2004-02-06 Thread Joshua D. Drake
> if its setup or not. I can handle the setup in steps (the "setup wizard") > but how do i check if the database/tables have > been setup? > It may be helpful to know which database as each database has there own way... > (and my apoligies for using "setup" so many times :-p ) > > Any advise,