Page 1 of 1
MySQL - id auto increment making insertion of same data
Posted: Sun Jun 25, 2006 7:42 am
by kabuki1985
I set the id as primary key and also auto increment. But if i enter the same data, it will be interpretted as a different data because of the different id from the auto increment. How do i prevent it from re-entering the same data?
Posted: Sun Jun 25, 2006 8:01 am
by feyd
check first.
Posted: Sun Jun 25, 2006 8:02 am
by kabuki1985
I set another attribute in the table as unique. So that prevents me from reentering redundant data. Duplicate entry '224924' for key 2.
I am retrieving an xml data from spongecell and updating my database accordingly. So how can i only update the changes from the calendar events that i have set?
Posted: Sun Jun 25, 2006 8:03 am
by kabuki1985
ok i'll look that up
Posted: Sun Jun 25, 2006 8:30 am
by kabuki1985
Yes, searched on check and it work well. Never thought of that. Sorry for my noobness.
