List of MySQL datatypes?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Is there's a built-in object inside of mySQL that hold its various
datatypes?  As an example, I'd like to populate an array with the
following values: "BOOL", "INT","VARCHAR","MEDUIMINT","ENUM" and so on.


Re: List of MySQL datatypes?

Quoted text here. Click to load it

I don't know of a place that lists all of the supported datatypes.
If you use MySQL 5.0, you can use the information_schema database to get a
list of all datatypes currently in use in all databases on the system:

    select distinct data_type from information_schema.columns order by 1

See for more
details about the information_schema database in MySQL 5.0.

Bill K.

Re: List of MySQL datatypes?


This is a *Very* good start for me.  Using this workaround, I will just
have to create a "dummy" table using all of the MySql datatypes.  You
saved the day ;-)


Bill Karwin wrote:
Quoted text here. Click to load it

Site Timeline