SQL Help Articles

The articles and tips at left are a few items that I hope will clarify common items that crop up in sql. All are written for use in mysql specifically, though I believe I have stuck enough to standard SQL that little or no changes will be necessary to implement them.

A noted item will be the one on using last_insert_id and auto incrementing columns, though the use of sequences in other database applications should closely resemble what is discussed in the articles.