Databases: Identify tables updates upon assignment submission

Databases: Identify tables updates upon assignment submission

by faisal memon -
Number of replies: 1

Hello Everyone,

  I am currently doing an implementation and conducting research on integration options. Like in MsSql we have the option to run profiler; is there a similar option in MySql. The reason i am asking is to use this feature to identify the tables that get updated when the following happens

Assignement is submitted

Quiz is posted

Discussion is poted

Grades are posted

 

Average of ratings: -
In reply to faisal memon

Re: Databases: Identify tables updates upon assignment submission

by Tomasz Muras -
Picture of Core developers Picture of Plugin developers Picture of Plugins guardians Picture of Translators

Hello Faisal,

You could enable general query log in MySQL. This will log every single SQL request (to a file or to DB table), then do your action (like posting a quiz) and read the log.

Best regards,
Tomasz Muras
Enovation Solutions

Average of ratings: -