if value is >65 transfer to different DB

https://stackoverflow.com/questions/…rts-new-data-t

I tried the link above but receiving a syntax error, my is easier then that one.
I have datetime, temperature, and humidity written in a table called tempdata.
I would like to have trigger that if value is above 65 for temperature (float), write to a different table or database called test.
Then email out when test is modified.

I have phpmyadmin 4.5.4
mysql ver 14.14 distrib 5.7.20
python 2.7.12
Ubuntu mate 1.16.2
Gnome 2
Raspberry pi…

if value is >65 transfer to different DB
Digital Point

Leave a Reply

Your email address will not be published. Required fields are marked *