Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL)

Register Sign In

Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL)

InsiteFX
Super Moderator
Posts: 6,326
Threads: 290
Joined: Oct 2014
Reputation: 235

#2

09-05-2016, 04:45 AM

I would think that any foreign key check would be a performance hit because it would need to check every record.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009. ( Skype: insitfx )

Messages In This Thread

Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by skunkbad - 09-04-2016, 11:28 AM

RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by InsiteFX - 09-05-2016, 04:45 AM

RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by skunkbad - 09-05-2016, 02:48 PM

RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by InsiteFX - 09-06-2016, 03:17 AM

RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by dave friend - 09-07-2016, 03:06 PM

RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by skunkbad - 09-07-2016, 04:22 PM

Theme © iAndrew 2016 - Forum software by © MyBB