MySQL Datatypes are broadly classified into three categories namely:
1) Numeric Datatypes
These include Int, TinyInt, SmallInt, MediumInt, BigInt, Float, Double, Decimal
2) Date and Time
These include Date, DateTime, TimeStamp, Time, Year
3) String types
These include Char, Varchar, Blob, Text, TinyBlob, TinyText, MediumBlob, MediumText, LongBlob, LongText, Enum
There are four types of Datatypes for date in oracle including the support to the time and timezone info alongwith daylightsavings time where applicable
This explains how to select particular Database from mysql databases from PHP.