Description
The MySQL Library SL enables a direct connection between a MySQL database and a CODESYS V3 control application to read and write data — without additional drivers or additional software on the controller.
So you can get started right away, we offer the library as a download. A license is not required for use. If you need further assistance, please do not hesitate to contact us.
Download Purchase license Get support
Licensing:
Without purchase of a license (only Download) the library runs for 30 minutes as an unrestricted trial version. For productive use a Single License (SL) / single-device license is required per controller. For instructions on installing licenses, please visit the page Product Licensing.
Overview
Execute SQL commands and conveniently read query results directly from the CODESYS application.
Description
With the MySQL Library SL you can send SQL queries from your CODESYS V3 application to a MySQL database. Standard SQL operations such as INSERT, SELECT, UPDATE, DELETE as well as other commands (e.g. ALTER, DROP, etc.) are supported.
For example, you can:
continuously write measured values, counter readings and production data into tables
read configuration data or recipes from the database
provide historical data for trend curves and analyses
pass data to third-party systems for further processing (ERP, SCADA, reporting)
Key features:
Direct connection to external or internal MySQL databases
No additional drivers or middleware required on the PLC
Worldwide access possible (dependent on network/IT infrastructure)
Storage of large amounts of data from the controller (e.g. IoT/field device data)
Sample project (CFC/ST) with visualization for a quick start
Details
Documentation Version
1.3.2.6
Placeholder
MySQL
Available in CODESYS Store
No
Programming System
CODESYS V3.5.17.2 or higher
Runtime System
CODESYS Control V4.2.0.0 or higher
Licensing
Single License (single-device license)
License
Last updated