Description


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.

up-right-from-squareDownload sealPurchase license questionGet support

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


Last updated