5,838
edits
Category:Cumulus MX: Difference between revisions
m
→MySQL settings
m (→MySQL settings: Changed <#metdate to <#metdate yesterday as found it had created wrong primary key) |
m (→MySQL settings) |
||
| Line 327: | Line 327: | ||
** This feature allows you to specify your own SQL for an upload to be repeated every NN seconds. There are 3 items: | ** This feature allows you to specify your own SQL for an upload to be repeated every NN seconds. There are 3 items: | ||
*# A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. | *# A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. | ||
*# The SQL you want to run, it should include INSERT IGNORE (or REPLACE or UPDATE) to insert a row, the name of the table, the columns to be updated and the values you include in your SQL are expressed as web tags. | *# The SQL you want to run, it should include INSERT IGNORE (or REPLACE or UPDATE) to insert a row, the name of the table, the columns to be updated and the values you include in your SQL are expressed as web tags. You can have more than one SQL statement in this box (end each with semi-colon) so you might want to add a delete "DELETE FROM YourTableName WHERE LogDateTime < DATE_SUB(NOW(), INTERVAL 7 DAY);" after your update/insert command to replicate the retention option of the previous feature, in this case deleting rows over a week old. | ||
*# The number of seconds between runs, the default is 10, but if your weather station updates less frequently, maybe you will choose 40 or 60 as the interval. | *# The number of seconds between runs, the default is 10, but if your weather station updates less frequently, maybe you will choose 40 or 60 as the interval. | ||