MySQL
Version:
Current
Last modified: October 19, 2020
Connection Type | ODBC (32- and 64-bit) |
Type of Support | Read & Write, In-Database |
Validated On | Database version 5.1 |
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.