> > > is it possible to get information about tables by doing queries on
> > system
> > > tables? I am using mysql version 4.1.11 on debian sarge.
> > >
> > > In my case I need to know which columns (names and types) a table has,
> > > and
> > how
> > > the primary key is defined.
> > >
> > > How can I get this information out of mysql by only using sql ?
> > Have a look at the SHOW commands in the documentation.
> I know about the "show create table ..." but it doesn't really satisfy my
> needs... Is there really no other way apart of parsing "create table"
> (I needed to this with firebird, and found all I could dream of in the
As I said -- take a look at the SHOW commands in the documentation :-)
There's "show columns" for example.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!