retreiving column names and types

retreiving column names and types

am 27.12.2003 01:42:00 von dcanham

Is there a relatively easy way in sql to retreive the column name and data
types in a parsable format?

-Daniel Canham


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: retreiving column names and types

am 27.12.2003 02:12:57 von Reggie Burnett

Describe will give you rowset

Describe ;


> -----Original Message-----
> From: Daniel Canham [mailto:dcanham@rochester.rr.com]
> Sent: Friday, December 26, 2003 6:42 PM
> To: win32@lists.mysql.com
> Subject: retreiving column names and types
>
> Is there a relatively easy way in sql to retreive the column name
> and data
> types in a parsable format?
>
> -Daniel Canham
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=rykr@bellsouth.net



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: retreiving column names and types

am 27.12.2003 05:24:50 von Petr Vileta

show fields from

Petr Vileta, Czech republic

----- Original Message -----
From: "Daniel Canham"
To:
Sent: Saturday, December 27, 2003 1:42 AM
Subject: retreiving column names and types


> Is there a relatively easy way in sql to retreive the column name and data
> types in a parsable format?
>
> -Daniel Canham
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=petr@practisoft.cz


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: retreiving column names and types

am 29.12.2003 09:55:42 von dcanham

Thanks Reggie, Virginia, and Petr for taking the time to reply to my
question. I'm very happy with the support the community offers here, and
hope to become knowledgable enough to contribute in the future. Your
anwsers pointed me in the right direction. The syntax ended up being:

SHOW COLUMNS FROM

the response query then returns 3 columns of

Column Name
Data Type
NULL Allowed

There was one row for each field present in the column. This will allow me
to parse in the results programatically and act on them.

-Daniel Canham


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: retreiving column names and types

am 29.12.2003 10:43:31 von Octavian Rasnita

Or you can use:

describe table;

----- Original Message -----
From: "Daniel Canham"
To:
Sent: Monday, December 29, 2003 10:55 AM
Subject: RE: retreiving column names and types


> Thanks Reggie, Virginia, and Petr for taking the time to reply to my
> question. I'm very happy with the support the community offers here, and
> hope to become knowledgable enough to contribute in the future. Your
> anwsers pointed me in the right direction. The syntax ended up being:


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org