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
detailed
instructions already posted at:
http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2
On Fri, 17 Mar 2006, Yves Glodt wrote:
> To: mysql@lists.mysql.com
> From: Yves Glodt <[EMAIL PROTECTED]>
> Subject: getting table metadata
>
> Hi,
>
>
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
Hi,
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 information out of mysql by
