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 *** --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://support.powerio.com/hub/codesys-hvac/en/mysql-library/description.md?ask=