Bill’s Dev Blog

MySQL has some nifty extensions to ANSI SQL. Two of which are “INSERT … ON DUPLICATE KEY UPDATE” and “REPLACE” (As of MySQL 4.1). These statements are used when inserting data into a table where the unique key of the row you are inserting may already exist, and if it does, you want this row [...]

I use MySQL a lot and when designing queries, I use the EXPLAIN keyword to help optimize performance. This can be done at any MySQL command prompt. However, it is not so easy in Oracle I am finding out. One drawback is that you need to use the SQL Plus client, as other Oracle command [...]