Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

Need to add a column to MySql DataBase, where I can track the last user who made changes to the information.VB.NET

I have a programm in VB.NET   that requires a correct log in, in order to access to it. Once the user has accesed to it, he can make changes to the information. I want to have a column where I can check who was the last that modified that information.


Thanks.
0
zandizza
Asked:
zandizza
1 Solution
 
DalHorinekCommented:
I guess you have an id of your users. So add a column last_id_user to the information table and on every change do something like

update information_table set last_id_user = <id_of_current_user>

Maybe I don't understand well the question.
0
 
zandizzaAuthor Commented:
yes, that is exactly what I am looking for. To set a record of everyone who has update information.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now