Timeline for Resolving DUPLICATE for a column with UNIQUE
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 27, 2012 at 14:31 | history | edited | onlineapplab.com | CC BY-SA 3.0 |
misspelled user name
|
| Nov 27, 2012 at 11:40 | history | edited | onlineapplab.com | CC BY-SA 3.0 |
added 1 characters in body
|
| Nov 27, 2012 at 9:17 | vote | accept | Googlebot | ||
| Nov 27, 2012 at 0:23 | comment | added | Googlebot | now it seems to be a practical solution! | |
| Nov 26, 2012 at 22:13 | comment | added | onlineapplab.com |
Use stored procedure which will check if given value already exists and in such case will return updated value so it will be something like ... ON DUPLICATE KEY UPDATE title = myTitleChecker(VALUES(title)), abr = myAbrChecker(VALUES(abr)), myNameChecker(VALUES(name));
|
|
| Nov 26, 2012 at 21:43 | comment | added | Googlebot |
How should I know that the duplicate is on the column title? it can be from columns abr or name, which are also UNIQUE.
|
|
| Nov 26, 2012 at 13:36 | history | edited | onlineapplab.com | CC BY-SA 3.0 |
deleted 4 characters in body
|
| Nov 26, 2012 at 13:28 | history | answered | onlineapplab.com | CC BY-SA 3.0 |