#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    12
    Rep Power
    0
    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    London, England
    Posts
    251
    Rep Power
    14
    I might be completely misunderstanding what you're trying to do but is it:

    SHOW TABLES
    SHOW COLUMNS FROM tablename

    ?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    12
    Rep Power
    0
    Nope you're right on. I thought it was something like that.

    Thank you.

Similar Threads

  1. Should any column names be avoided? Using prefixes?
    By RyanA in forum Database Management
    Replies: 17
    Last Post: December 9th, 2008, 02:15 AM
  2. Displaying mySQL column names using PHP
    By brett_webb in forum PHP Development
    Replies: 6
    Last Post: June 13th, 2007, 08:53 AM
  3. Dynamically retrieving column names
    By adamgernon in forum MySQL Help
    Replies: 0
    Last Post: September 22nd, 2003, 10:15 PM
  4. User friendly column names (labels) techniques
    By hayden in forum MySQL Help
    Replies: 3
    Last Post: September 23rd, 2001, 02:48 PM
  5. Setting USER & PWD for *tables*??
    By Nightspirit in forum MySQL Help
    Replies: 3
    Last Post: September 26th, 2000, 06:04 AM

IMN logo majestic logo threadwatch logo seochat tools logo