Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Field descriptions

Posted on 2006-07-06
3
923 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL  on Tomcat 8 68
MySqlDump not dumping triggers 1 43
I want to echo out my field names with its values into a table 10 36
Excel - SQL export question 3 49
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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