Multiple users. Last user changing the data row.

[expired user #9567]'s profile image [expired user #9567] posted 8 years ago in Feature discussion Permalink

Hello all. Timestamp is a brilliant feature of HeidiSQL, allowing one to trace the last change in time expression. Is there a way to stamp the last user who committed changes to a data row? Assuming the database is managed by a number of users, and it's critically important to know who exactly made the last change.

In HeidiSQL, data changes on-the-fly once the user escapes the cell as opposed to SQL Workbench where the user needs to hit the "Apply" button and, thus, thinks twice.

kalvaro's profile image kalvaro posted 8 years ago Permalink

Timestamp a HeidiSQL feature??

You could write a variety of log tables and triggers but, IMHO, the time you'd need to do it would be better used creating a proper CRUD application and preventing direct access to database.

Please login to leave a reply, or register at first.