CUSTOM REPORTING need file layout or schema

#1 (**permalink**) 05-24-2008, 07:09 AM

I need to do some custom reporting from an application based on mysql.
I plan to use crystal reports. Is there a way to print a schema or
file layout of the database. I've fina;;y gotten connected to it with
odbc, now if I had a schema I could probably figure out where the data
I need is located. Thanks for reading.

#2 (**permalink**) 05-24-2008, 07:09 AM

On 20 May, 18:00, cyphr...@penn.com wrote:
> I need to do some custom reporting from an application based on mysql.
> I plan to use crystal reports. Is there a way to print a schema or
> file layout of the database. I've fina;;y gotten connected to it with
> odbc, now if I had a schema I could probably figure out where the data
> I need is located. Thanks for reading.

It's in the manual, Thanks for reading (or not in your case)!
http://dev.mysql.com/doc/refman/5.0/...ate-table.html

#3 (**permalink**) 05-24-2008, 07:09 AM

On Tue, 20 May 2008 20:00:54 +0200, <cyphrbob@penn.com> wrote:

> I need to do some custom reporting from an application based on mysql.
> I plan to use crystal reports. Is there a way to print a schema or
> file layout of the database. I've fina;;y gotten connected to it with
> odbc, now if I had a schema I could probably figure out where the data
> I need is located. Thanks for reading.

Aside from show create table, there is also the INFORMATION_SCHEMA
database available to you. Query away in SQL, and it will tell you all you
want to know about the database.
--
Rik Wasmus
....spamrun finished

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode