> How can i extract names of columns from table? I am doing select *
> from table, then i want to get name of columnsis it possible?
"show columns from XXX" where XXX is the name of the table.
sql, query
-
Before posting, pl
> How can i extract names of columns from table? I am doing select *
> from table, then i want to get name of columnsis it possible?
Use desc or describe.
http://www.mysql.com/doc/en/DESCRIBE.html
David
-
Before posting,
Hello,
How can i extract names of columns from table? I am doing select *
from table, then i want to get name of columnsis it possible?
--
Best regards,
Martin mailto:corwin@;corwin.sk
for filter - sql and query
--
Try:
Desc name_table
- Original Message -
From: Martin Hudec <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 12:31 PM
Subject: getting name of columns
> Hello,
>
> How can i extract names of columns from table? I am doing select *
>