View Single Post

  #1 (permalink)  
Old 05-22-2008
JRough
 
Posts: n/a
Default 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
Reply With Quote