MohitPandit
asked on
MySQL: To find out how many columns updated in the table
Hi,
I've a scenario in MySQL.
Whenever, a table columns updated by different users then I need to find out how many columns updated then I need to check if greater than 4 columns updated then I need to store in different table for history purpose.
Is there any way to track in MySQL like using trigger or like in SQL Server provides Columns_Updated function?
Regards,
MohitPandit
I've a scenario in MySQL.
Whenever, a table columns updated by different users then I need to find out how many columns updated then I need to check if greater than 4 columns updated then I need to store in different table for history purpose.
Is there any way to track in MySQL like using trigger or like in SQL Server provides Columns_Updated function?
Regards,
MohitPandit
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sure no probs, glad it helped, and good stuff for working it out ;)