471,050 Members | 1,350 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

How To: RETRIEVE FIELD NAMES from a TABLE???

What MySQL command would I use if I wanted it to return to me the
names of every field in one of the database's tables?

Thank in advance.
Jul 20 '05 #1
4 2211
"Alan Mailer" <cl**********@earthlink.net> wrote in message
What MySQL command would I use if I wanted it to return to me the
names of every field in one of the database's tables?


Try the "describe mytable" command.

Or you can select from the system table in the mysql database.
Jul 20 '05 #2
"Alan Mailer" <cl**********@earthlink.net> wrote in message
What MySQL command would I use if I wanted it to return to me the
names of every field in one of the database's tables?


Try the "describe mytable" command.

Or you can select from the system table in the mysql database.
Jul 20 '05 #3

"Siemel Naran" <Si*********@REMOVE.att.net> wrote in message
news:gW********************@bgtnsc04-news.ops.worldnet.att.net...
"Alan Mailer" <cl**********@earthlink.net> wrote in message
What MySQL command would I use if I wanted it to return to me the
names of every field in one of the database's tables?


Try the "describe mytable" command.

Or you can select from the system table in the mysql database.


Or you can try 'SHOW FIELDS FROM TABLE'
Jul 20 '05 #4

"Siemel Naran" <Si*********@REMOVE.att.net> wrote in message
news:gW********************@bgtnsc04-news.ops.worldnet.att.net...
"Alan Mailer" <cl**********@earthlink.net> wrote in message
What MySQL command would I use if I wanted it to return to me the
names of every field in one of the database's tables?


Try the "describe mytable" command.

Or you can select from the system table in the mysql database.


Or you can try 'SHOW FIELDS FROM TABLE'
Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Don Leverton | last post: by
2 posts views Thread by John T. McCraw | last post: by
8 posts views Thread by RP | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.