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 2 Thank You
Deal with logic in the application not the database. Otherwise if you feel you must do it, I would probably opt for a trigger and a federated table schema.