Hi,
"SHOW CREATE TABLE ...." show you all what you need about table requested.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Lon Lentz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 12:23 AM
Subject: RE: mysql equiv for syscolumns?
>
> What I need to obtain is the table information. Column names, type,
> length, etc. Someone suggested using the EXPLAIN or DESCRIBE commands, but
> ColdFusion is not returning it as a valid queryset. Are the result sets of
> these commands ODBCable? I am using MyODBC on Linux.
>
>
> -----Original Message-----
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 4:53 PM
> To: Lon Lentz
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysql equiv for syscolumns?
>
>
> On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote:
> >
> > I have a web based ad hoc query builder I built for running
> > against SQL Server databases. I am trying to port it to mysql. I
> > need a way to return table info through a query. Is there a way to
> > return syscolumns type info in standard column and row format?
>
> It might be helpful to describe what you need without using SQL Server
> terminology. A lot of folks here have never used the product but
> could probably help you anyway.
>
> Jeremy
> --
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
>
> MySQL 3.23.51: up 14 days, processed 287,167,474 queries (228/sec. avg)
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
