How and with which library to create MySQL triggers in C++?

Question

MySQL

There is a smart home project involving Raspberry pi, it includes: a Java application for android and a daemon for Raspberry pi in C ++ that polls the MySQL database when changes occur in a certain table (which are sent from a Java application) Raspberry should, for example: power a relay, turn on the light, etc., the question is that I still have no idea how to implement it (Or rather, how to create triggers for MySQL in C ++)

Answer 1

How to create triggers: https://habr.com/ru/post/37693/
You can create one-time with any MySQL client.
How to manage peripherals: You need to read the relevant manuals.