TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Chaitanya
NA
58
57.1k
How can I make sure that duplicate data does not insert while updating
Aug 17 2012 7:29 AM
Hi all I am using MYSQL database. My table is as follows
EmpID
FirstName
LastName
Middle
1001
Chaitanya
V
P
As per my requirement I would like to keep track the changes of employee details in the table when he tries to edit and update the data.
This data I will show in a gridview, not when user edits and update the data I would like to update the data only if changes are there. Means if he edits FirstName to Chaitu or LastName to D or Middle to Q or some other then only I would like to update the data.
If he tries to update it with the same data I don't want to update the record
Reply
Answers (
1
)
MS Access update command
what is diffrence between SQL and |ORACLE ?