Re: selecting field information in SQL

In article <3AE9A746.7A3F092B_at_netscape.net>, kelli norman <kellikellin_at_netscape.net> wrote:

| i hope this doesn't sound totally confusing:
| how do i get certain fields' information from a table, even if no
| records exist? i need to get information about the fields (size and if
| numeric) of a table that i usually get with my select stmt, but my
| select statement will sometimes return an empty record set and so i
| don't get the field information.
|
| i'm using mysql.

SHOW COLUMNS FROM <tablename>;

--