Execute SQL commands and conveniently read query results directly from the CODESYS application.
{% endcolumn %} {% column width="8.333333333333343%" %} {% endcolumn %} {% endcolumns %} *** ### 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 ***