How to write flexible INSERT and UPDATE statements in MySQL at Xaprb
MySQL provides several variations on INSERT and UPDATE to allow inserting and updating exactly the desired data. These features provide a lot of power and flexibility, making MySQL significantly more capable than it otherwise might be.