For example, if you have a table logging the value and alarm state of five points, the table will have eleven columns.

Group logging tables contain a timestamp column, plus an additional column for each table and point attribute you have selected.All table rows include a timestamp column and an auto-increment sequence number that ensures that each row is unique. Alarm, Event, and Application logging tables have columns that are specific to that table, plus an additional column for each table attribute you have selected.For example, if you have a table that logs the point value and previous value for all points configured for data logging, the table will have four columns.

To create a new row identifier, the AUTOINCREMENT attribute can be assigned to the table column. The number of columns is independent of the number of points in the table. Auto increment is a useful function provided by MySQL.

Data logging tables contain a timestamp and Point ID column, plus an additional column for each table and point attribute you have selected.

The following columns are defined for each type of log file: The Database Logger tables have the following characteristics: Column Definitions For Auto Increment You can create a sequence as below.

Tableplus auto increment