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
> 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,
2 matches
Mail list logo