MySQL
Version:
2023.1
Last modified: May 17, 2023
| Connection Type | ODBC (64-bit) |
| Type of Support | Read & Write, In-Database |
| Validated On | Database Version: 8.0.25 |
Driver Details
In-Database processing requires 64-bit database drivers.
Alteryx Tools Used to Connect
For Standard Workflow Processing
Limitations
Database Version 5.1
- Maximum Columns In Table: 4096
- Maximum Column Name Length: 64 Characters
- Maximum Row Size: 65535 Bytes (does not include LOB size)
ODBC Version 5.01.04.00 (32- and 64-bit)
- Fixed Numeric is transported as a SQL_C_CHAR; SQL_NUMERIC not supported.
- Known bug with BIT datatypes (MySQL Bug#37118): Returns false no matter what you do.
OLEDB
MySQL does not have a native OLEDB provider.
Spatial
- Projections are not supported for writing spatial data.
- The Spatial Match tool only supports the "Intersects" calculation type.
- The Find Nearest tool is not supported.