#5 - SCADA Ignition data logger into MySQL

In the previous post  we saw how to make a Chart in Ignition and how to store the data coming from PLCs in a MySQL database. In the example shown the 3 bank parameters used were:  

jdbc:mysql://localhost:3306/test

In this post we will see how to manipulate this data both in Ignition and MySQL.

1.  Ignition:

• Trend being logged with process data
• Click Tools> DB Query Browser

• Write the query with MySQL statements / queries

The timestamp is in Unix format. There are several timestamp converters on the internet.

2. MySQL:

The same query can be executed from the MySQL Server 

Note: The documentation has more details about the historical database as well as the description of each table.