MySQL
Connection Type | ODBC (64-bit) |
Type of Support | Read & Write, In-Database |
Validated On | Database Version: 8.0.25 ODBC Client Version: 1.1.2.1002 |
Alteryx Tools Used to Connect
For Standard Workflow Processing
For In-Database Workflow Processing
Limitations
Maximum Columns In Table: 4096
Maximum Column Name Length: 64 Characters
Maximum Row Size: 65535 Bytes (does not include LOB size)
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.
MySQL does not have a native OLEDB provider.
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.
When writing to MySQL with the output option Update: Insert if New, make sure you have selected Return matched rows instead of affected rows in your driver DSN Setup.