April 24, 2024

Mind of Marcuzio

Performance tuning is the art of wasting ten days to save ten seconds.

Classic ASP: Getting MySQL DB Schema Information

Difficulty Level    

You may have been able to tell by now that I’m a fan of Classic ASP, err…. Active Server Pages.  I love how simple they are to learn, use and how much you can do with them to bring functionality to the web.  I usually use MySQL as the database I pull stuff from on the webpages I make and think this code might be helpful.  It will list all the Databases you’ve been given access to and Tables within those databases.  You can easily expand the code to list the columns in the tables, add tables, drop tables, etc…

[snippet id=”14″]

About The Author