insert on duplicate update, multiple keys
-
I'm trying to use "insert... on duplicate key update" on a table with multiply unique keys, but MySQL fails to recognize them. It only recognizes the first column as a primary key. Is there anything additional I can do to force it to recognize the other four keys, or I'll have to create a procedure for this to work? Anyone got any idea?
Where it seems there are only borderlines, Where others turn and sigh, You shall rise!
-
I'm trying to use "insert... on duplicate key update" on a table with multiply unique keys, but MySQL fails to recognize them. It only recognizes the first column as a primary key. Is there anything additional I can do to force it to recognize the other four keys, or I'll have to create a procedure for this to work? Anyone got any idea?
Where it seems there are only borderlines, Where others turn and sigh, You shall rise!
I have the same problem. Have you found a solution? Thanks.