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,
Hey,
Sometime back i was checking out a script and it had a very useful little
bit, in the scripts control panel there was
a text link that said "click here to see if your database has been setup"
when you click it, it will tell you if its setup
or lauches the setup script to help you set it up.
I
3 matches
Mail list logo