On Friday 17 March 2006 16:50, Martijn Tonies wrote:
> Hello Yves,
> As I said -- take a look at the SHOW commands in the documentation :-)
"show columns from TABLE" seems to be what I need, thanks to you and the other
posters, have a nice weekend! (and sorry for the noise)
best regards,
Yve
-Original Message-
From: Yves Glodt [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17, 2006 9:22 AM
To: mysql@lists.mysql.com
Subject: Re: getting table metadata
On Friday 17 March 2006 15:52, Martijn Tonies wrote:
> Hello Yves,
Hello Martijn,
> > is it possible to get informa
Hello Yves,
> > > is it possible to get information about tables by doing queries on
some
> >
> > 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
Try "DESC table_name".
Yves Glodt пишет:
On Friday 17 March 2006 15:52, Martijn Tonies wrote:
Hello Yves,
Hello Martijn,
is it possible to get information about tables by doing queries on some
system
tables? I am using mysql version 4.1.11 on debian sarge.
In my case I need to know whic
If you upgrade to mysql 5.0.x there are also the
The INFORMATION_SCHEMA tables that return meta information
about tables.
AFAIK they may not be available in pre 5.0 versions.
Keith
In theory, theory and practice are the same;
in practice they are not.
To unsubscribe from this list, please see d
On Friday 17 March 2006 15:52, Martijn Tonies wrote:
> Hello Yves,
Hello Martijn,
> > is it possible to get information about tables by doing queries on some
>
> 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)
Hello Yves,
> is it possible to get information about tables by doing queries on some
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 informatio
