List of MySQL datatypes?

[circuit_breaker]

Hi,

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.

Thanks.

[Bill Karwin]

"circuit_breaker" <ci*************@canada.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi,

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.

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 http://dev.mysql.com/doc/refman/5.0/...on-schema.html for more
details about the information_schema database in MySQL 5.0.

Regards,
Bill K.

[circuit_breaker]

Bill,

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 ;-)

Thanks.

Bill Karwin wrote:

"circuit_breaker" <ci*************@canada.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi,

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.

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 http://dev.mysql.com/doc/refman/5.0/...on-schema.html for more
details about the information_schema database in MySQL 5.0.

Regards,
Bill K.