Here's an SQL Injection Cheat Sheet

Webapper has good review of how to manage next ID functionality.

Data Generator is a simple web-based tool that lets you create large volumes of random, custom data for use in testing software. You can have your data formatted in HTML tables, CSV or SQL statements. They also offer a free desktop application that will generate larger sets of data. Check it out next time your in need of sample data.

Some good words on MySQL...

Google Video: MySQL Performance Tuning Best Practices

MySQL Optimization Hints

If you have developed a web application with a database back-end, you should check out this article titled SQL Injection Attacks by Example. It clearly explains what a SQL injection attack is and shows you how defend against such attacks.

OReillys MacDevCenter has an article that will help you with Managing MySQL on Mac OS X. Their coverage includeds installing mySQL then getting a GUI based tool to manage your databases.

Some good discussion going on here.

As usual Ray Camden is leading the way and others, Rob Gonda and WaterSwing have followed.

Ray has sparked some good comments on getting your SQL query to run quick. It's all down to the index!

Here's the posting.

MySQL has always had a great clause in the SELECT function called LIMIT which allows you to get to a subset of records in the db. MS SQL Server doesn't have that.

I found this blog entry which also directed me to this MS TechNote which seems to offer a soluction.

Here's the code:

SELECT TOP <pageSize> CustomerID,CompanyName,ContactName,ContactTitle
  FROM
  (SELECT TOP <currentPageNumber * pageSize> 
          CustomerID,CompanyName,ContactName,ContactTitle 
   FROM 
     Customers AS T1 ORDER BY ContactName ASC)
  AS T2 ORDER BY ContactName DESC