On duplicate key?

lurtnowski · September 8, 2020, 11:14pm

I haveethe query

INSERT INTO object_locations (type,room_id,pdu_id,x_coord,y_coord) VALUES ('pdu',3,3,299,116) ON DUPLICATE KEY UPDATE x_coord = 299,y_coord = 116

When I run it,

why is a record INSERTed when their is a PK (pdu_id) of 3 in the table? Shouldnt it UPDATE?

m_hutley · September 8, 2020, 11:17pm

show us the table definition?

system · December 9, 2020, 6:17am

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.