Syntactic Confectionery Delight | |
PerlMonks |
Re: Of Mysql, DBI and PK best practicesby jimbus (Friar) |
on Apr 17, 2007 at 14:32 UTC ( [id://610534]=note: print w/replies, xml ) | Need Help?? |
I parallel posted this to MySQL's forum and it was suggested that I was looking for the MySQL syntax "INSERT ... ON DUPLICATE KEY UPDATE". I'd never heard of such a thing and a brief google search showed it is probably what I'm looking for (I'm a pretty big believer that with reasonable usage, the db is usually going to be more efficient that anything I write). I spent hours searching Google for options on what I was seeing: "MySQL primary key violation on insert" and got no where.
--Jimbus aka Jim Babcock Wireless Data Engineer and Geek Wannabe jim-dot-babcock-at-usa-dot-com
In Section
Seekers of Perl Wisdom
|
|