Register / Login

Post Reply Bookmark Topic Watch Topic
New Topic

programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums

this forum made possible by our volunteer staff, including ...

Marshals:

Campbell Ritchie
Tim Cooke
Liutauras Vilda
Jeanne Boyarsky
paul wheaton

Sheriffs:

Ron McLeod
Devaka Cooray
Henry Wong

Saloon Keepers:

Tim Holloway
Stephan van Hulst
Carey Brown
Tim Moores
Mikalai Zaikin

Bartenders:

Frits Walraven

Forum:

JDBC and Relational Databases

Retrieve MySQL table column names

Bryan Scarbrough

Ranch Hand

Posts: 49

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

How can I get the column names from a MySQL table?

Bryan Scarbrough<br /> <br />Consistency is the last resort of the unimaginative!

Ranch Hand

Posts: 49

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Run the query as select *, get ResultSetMetaData from the ResultSet, use getColumnCount to get number of columns and then loop through to get name using getColumnName

Padma

Bryan Scarbrough

Ranch Hand

Posts: 49

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks, that was easier than I thought it would be!

Bryan Scarbrough<br /> <br />Consistency is the last resort of the unimaginative!

Popeye has his spinach. I have this tiny ad:

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing

reply

Bookmark Topic

Watch Topic

New Topic

Boost this thread!

Similar Threads