Wednesday, September 16, 2009
Database Normalization Basics
In this article, we'll introduce the concept of normalization and take a brief look at the most common normal forms.
MySQL Handling Duplicates
Tables or result sets sometimes contain duplicate records. Sometime it is allowed but sometime it is required to stop duplicate records. Sometime it is required to identify duplicate records and remove them from the table. This chapter will describe how to prevent duplicate records occurring in a table and how to remove already existing duplicate records.
INSERT ON DUPLICATE KEY UPDATE - MySQL
INSERT ... ON DUPLICATE KEY UPDATE is a very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1.
Friday, September 04, 2009
Thursday, September 03, 2009
Subscribe to:
Posts (Atom)