MySQL Database Connectivity
The WPS Engine for MySQL module provides connectivity to version 5 (and upwards) of the MySQL database.
| Type of Access | Supported? |
|---|---|
| Reading |  |
| Writing | |
| Updating | |
| Creating New Tables | |
| Implicit Pass Through Support | |
| Explicit Pass Through Support | |
| Bulk Loading | |
The WPS engine for MySQL connects to a MySQL database using the Connector/C API.
Dependencies and Usage
You can only do update and delete processing on MySQL tables that have a primary key defined.
The WPS Engine for MySQL can only be used on the supported platforms indicated in the table below.
| Platform | Supported? |
|---|---|
| AIX on System p (POWER) | |
| Linux on ARM | |
| Linux on System p (POWER) | |
| Linux on x86 | |
| macOS on x86 | |
| Solaris on SPARC | |
| Solaris on x86 | |
| Windows on x86 | |
| Linux on Mainframe System z | |
| z/OS on System z |  |
