devexp DEVelopment EXPerience, shared with the world!

forgotten syntaxes for MySQL

A lot of people seem to have problems with updating or inserting data in tables in an intelligent way. We shouldn't point a finger to those who don’t use the correct syntax for the problem it solves, because there are a lot of different ways to do this, but I wanted to create a little list of interesting syntax's that are often forgotten and never used. I will talk about:

• insert... on duplicate key update
• replace
• insert... select
• Load data infile and select into outfile
• delayed