AUTO_INCREMENT is Evil!

• ... or at least using them blindly is.

• Often, there is a natural primary key.

• Examples:

• Social networking (user_id, other_user_id).

• Forum, (thread_id, message_id).

• Wikipedia revisions (rev_page, rev_id).