Can I launch a trigger on select statement in mysql?

by

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).

More Related Contents:

  1. Throw an error preventing a table update in a MySQL trigger
  2. MySQL Trigger after update only if row has changed
  3. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. Is there a MySQL option/feature to track history of changes to records?
  7. Binary Data in MySQL [closed]
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. MySQL trigger On Insert/Update events
  11. Check for x consecutive days – given timestamps in database
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. MySQL trigger to update a field to the value of id
  15. How can I set a maximum number of rows in MySQL table?
  16. My MySQL trigger doesn’t work, simple syntax, not complicated
  17. Case statement in MySQL
  18. How do I show the schema of a table in a MySQL database?
  19. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  20. MySQL concatenating all columns
  21. Remove special characters from a database field
  22. Proper database model for a user feedback system (an interesting case)
  23. How big can a MySQL database get before performance starts to degrade
  24. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  25. How to get multiple records against one record based on relation?
  26. Easiest way to copy a table from one database to another?
  27. What is the best way to store media files on a database?
  28. How to use a user variables in MySQL LIKE clause?
  29. remove all numeric characters from column mysql
  30. How to store data with dynamic number of attributes in a database

Leave a Comment