devexp

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

Read more…