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