Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- List of MySQL datatypes?
January 29, 2006, 1:44 pm
rate this thread
Re: List of MySQL datatypes?
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/en/information-schema.html for more
details about the information_schema database in MySQL 5.0.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum