I tried the previous link but when receiving a syntax error, it is easier than that.
I have date and time, temperature and humidity written in a table called tempdata.
I would like to have to activate that if the value is above 65 for the temperature (float), write in a different table or database called test.
Then send an email when the test is modified.
I have phpmyadmin 4.5.4
mysql see 14.14 distrib 5.7.20
Companion of Ubuntu 1.16.2
Raspberry pi 2