### **Numbers** :

| type | description | range | length | exemple |
| --- | --- | --- | --- | --- |
| **tinyint** | | `-128 to 127 (0-255)` | 2<sup>8</sup> | |
| **smallint** | | `-32768 to 32767 (0-65535)` | 2<sup>16</sup> | |
| **mediumint** | | `-8388608 to 8388607 (0-16777215)` | 2<sup>24</sup> | --- |
| **int** | |`-2147483648 to 2147483647 (0-4294967295)` | 2<sup>32</sup> | --- |
| **bigint** | | `-9223372036854775808 to 9223372036854775807 (0-18446744073709551615)` | 2<sup>64</sup> | --- |
| **decimal** | `store exact numeric values, best for business uses` | --- | --- | --- |
| **float** | --- | --- | --- | --- |
| **double** | --- | --- | --- | `DOUBLE(5,2) -> 123.45` |

### **Date & Hours** :
- **date**
- **datetime**
- **timestamp**
- **time**
- **year**

### **Strings** :
- **char**
- **varchar**
- **tinytext**
- **text**
- **mediumtext**
- **longtext**
- **json**

### **Lists** :
- **enum**
- **set**

### **Binaries** :
- **bit**
- **binary**
- **varbinary**
- **tinyblob**
- **blob**
- **mediumblob**
- **longblob**

### **Geometry** :
- **geometry**
- **point**
- **linestring**
- **polygon**
- **multipoint**
- **multilinestring**
- **multipolygon**
- **geometrycollection**