March 1st, 2013, 09:03 AM
How to find columns defined as SMALLINT
I'm new at using MYSQL so please forgive me if this should be obvioUs. How would you construct a query to find columns that are defined as SMALLINT?
Thanks in advance for any guidance provided.
March 1st, 2013, 09:35 AM
meta data for tables, columns etc. is available through the INFORMATION_SCHEMA database:
However, when you find yourself fumbling with the INFORMATION_SCHEMA, it's usually a sign that you're really, really on the wrong track -- unless you write a database adminstration system like phpmyadmin. What exactly do you need this for?
March 1st, 2013, 10:00 AM
It was an exercise in a tutorial, but I figured it out.