How to see old value of a data that was recently updated?

Question

0.00/5 (No votes)

See more:

Hello everyone,

I have a question that I have thought for a long time. We have database tables, rows and data inside them.

Let's think about a simple table that keeps the items that in my pocket.

İtems_in_my_pocket
id item_name item_price
0 cellphone $150
1 money $70
2 einac(just kidding) $500,000

I want to update 2nd and 3rd row. I decide the row via id.

PseudeCode

Update the row that has id = 2 set item_pice to $0.
Update the row that has id = 3 set item_name to wallet and item_pice to $20.

How could I know the old values of these data? If I wanted to create a log panel, then it would
contain you updated einac(just kidding) to wallet
and so on..

What are the possible solutions? Does this belong to DBMS or SQL or the code itself(c#, java, php etc.)

Thanks.
Emre.

Posted 10-Oct-13 2:42am

FoxRoot

Add a Solution

Comments

ZurdoDev 10-Oct-13 8:47am

Create a table where you store history.

FoxRoot 10-Oct-13 8:47am

How? Could you explain more ?

ZurdoDev 10-Oct-13 8:50am

Create a table where you store the ID of the item and the price. You'll also need a timestamp and maybe even who made the change. It really depends on what you actually need.

FoxRoot 10-Oct-13 8:52am

What will ı store in the new table? The old values?

ZurdoDev 10-Oct-13 8:53am

Yes. The current table will always have the current value. The history table will store the previous values.

FoxRoot 10-Oct-13 8:59am

Got it. Thanks for the responce. Have a nice day.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ArunRajendra · Accepted Answer · 2013-10-10T02:54:00

Solution 1

Here is a article for logging the database changes.

Audit Trail – Tracing Data Changes in Database[^]

Posted 10-Oct-13 2:54am

ArunRajendra

Comments

FoxRoot 10-Oct-13 9:00am

I gave an eye to the article, that is what I am looking for. I wiil look deeper now. Thanks

ArunRajendra 10-Oct-13 23:18pm

welcome