如何在php中的数据库中为选定的表创建sql日志？

Question

Case scenario :

Database : sample_db

Table's : table_1 ,table_2 , table_3 , table_4

All the table's has column row_id

I want to create sql queries log if there is any row insert/update/delete for row_id = 'some_value' for table_1 and table_3 for a sample_db

Edits :

Sample Example :

Let say there is a database school_db , which has following tables:

a.school. [school_id,school_name] 
b.class. [school_id,class_id,class_name]
c.section. [school_id,class_id,section_id,section_name]
d.marks. [school_id,student_id,marks]
e.exams. [school_id,class_id,exam_id,exam_name]

Now for a particular school's , let's say 'ABC school' which has school_id = 10 .

I want to log all the sql queries that are run for 'ABC school' for tables school,marks and exams.

Answer 1

You could use triggers in the database.

Something like this:

CREATE TRIGGER log_update AFTER UPDATE ON table_1
     FOR EACH ROW
     BEGIN
         IF NEW.row_id in ('some_value','some_other_value') THEN
             INSERT INTO log .....;
         END IF;
     END;

You replace the dots by somethign you want to insert into the log. Repeat this for table_3.

Also repeat this to replace UPDATE with DELETE.

You could use this to trigger on INSERT, but I don't see the point since row_id doesn't exist yet (assuming it's unique).