Solved

Field descriptions

Posted on 2006-07-06
3
922 Views
Last Modified: 2012-06-21
I am trying without success to get the field description from the table fields in a MySQL database into a C# program.

If someone would be so kind as to give me the "dummies" step by step version. I've Googled for it but got nothing I could understand. It seems like it should be something fairly simple. Please help.
0
Comment
Question by:Padriac
3 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 500 total points
ID: 17050584
If you are using mysql 5

You can go to

Information_Schema.COLUMNS and the COLUMN_COMMENT field

otherwise you can extract it from the show create table - and pull it from there
0
 
LVL 30

Expert Comment

by:todd_farmer
ID: 17056119
If you have MySQL 4.1, you can use the SHOW FULL COLUMNS FROM tablename syntax:

http://dev.mysql.com/doc/refman/4.1/en/show-columns.html

If you have 5.0, you can use the information_schema as Raynard7 said.
0
 

Author Comment

by:Padriac
ID: 17057834
Thanks Raynard7! That was just what I needed to get where I wanted. With your answer I was able to put together exactly the code I needed. Thanks again.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now