SQL query on information_schema
I'm trying to get a print out of the table structure of my
"_fakerockridge" database using information_schema. In PHPAdmin I
run thr SQL query but I get an error. Do I have to add all the tables
in information_schema? I got this example from the MYsql manual. It
seems like it should work. I just renamed the database to my database
name.
SELECT table_name, table_type, engine
FROM information_schema.tables
WHERE table_schema = '_fakerockridge'
ORDER BY table_name DESC;
I get the empty set:
LIMIT 0 , 30
|