|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I looking to make a web interface for mySQL hooked up to ODBC. What I want to be able to do is select a database in dsn and then use SQL to return:
(all table names) ->(all table's column names) Is there a way of doing this? Thanks, Terry Scott |
|
#2
|
|||
|
|||
|
I might be completely misunderstanding what you're trying to do but is it:
SHOW TABLES SHOW COLUMNS FROM tablename ? |
|
#3
|
|||
|
|||
|
Nope you're right on. I thought it was something like that.
Thank you. |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Displaying Table Names and Column Names... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|