MySQL Insert Statement ONLY IF a duplicate entry does not exist

This is a great way to reduce MySQL code/mistakes/annoyance when doing things, take for example this statement:

INSERT IGNORE INTO sometable(CatName) VALUES("someitem");

Notice the "IGNORE", that is what does the magic.

Normally if the entry "someitem" existed you'd get an error message back such as "Duplicate entry for whatever".  What I have normally done in PHP or whatever language is manually coded or made a helper function to return true/false if the same result/name already exists in the database.

Just note that the syntax has changed from a normal INSERT.


Tags:

mysql, insert, duplicate, entry, existthis, reduce, annoyance, sometable, catname, quot, someitem, php, manually, coded, helper, database, syntax,

Latest Articles

  • Linux tftp listens on all interfaces and IPs by DEFAULT Security Risk Hole Solution
  • python import docx error
  • Cisco Unified Communications Manager Express Cheatsheet CUCME CME
  • Linux Ubuntu Debian Missing privilege separation directory: /var/run/sshd
  • bash how to count the number of columns or words in a line
  • bash if statement how to test program output without assigning to variable
  • RTNETLINK answers: Network is unreachable
  • Centos 7 how to save iptables rules like Centos 6
  • nfs tuning maximum amount of connections
  • qemu-kvm error "Could not initialize SDL(No available video device) - exiting"
  • Centos 7 tftpd will not work with selinux enabled
  • Debian Ubuntu Mint Howto Create Bridge (br0)
  • How To Control Interface that dhcpd server listens to on Debian based Linux like Mint and Ubuntu
  • LUKS unable to type password to unlock during boot on Debian, Ubuntu and Mint
  • Debian Ubuntu and Linux Mint Broken Kernel After Date - New Extra Module Naming Convention
  • Wordpress overwrites and wipes out custom htaccess rules and changes soluton
  • Apache htaccess and mod_rewrite how to redirect and force all URLs and visitors to the SSL / HTTPS version
  • python 3 pip cannot install mysql module
  • QEMU-KVM won't boot Windows 2016 or 2019 server on an Intel Core i3
  • Virtualbox vbox not starting