CodingForums.com - View Single Post - Resolved using replace into

Old Pedant · 10-10-2012, 08:31 PM

It should be fine. Using INSERT...ON DUPLICATE KEY is probably slightly faster, but as you said: It's a small table. Yes, you *MUST* have a primary key. The docs point out that without one REPLACE is converted into a simple INSERT.

10-10-2012, 08:31 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,247 Thanks: 59 Thanked 3,998 Times in 3,967 Posts	It should be fine. Using INSERT...ON DUPLICATE KEY is probably slightly faster, but as you said: It's a small table. Yes, you MUST have a primary key. The docs point out that without one REPLACE is converted into a simple INSERT. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.