database - Can I launch a trigger on select statement in mysql?

Question

I am trying to run an INSERT statement on table X each time I SELECT any record from table Y is there anyway that I can accomplish that using MySQL only?

Something like triggers?

Answer 1

Short answer is No. Triggers are triggered with INSERT, UPDATE or DELETE.

Possible solution for this. rather rare scenario:

• First, write some stored procedures that do the SELECTs you want on table X.
• Then, restrict all users to use only these stored procedures and do not allow them to directly use SELECT on table X.
• Then alter the stored procedures to also call a stored procedure that performs the action you want (INSERT or whatever).