MySQL Bulk Insert or Update

MySQL Bulk Insert or Update

Any technique that saves round trips to the database pays for itself exponentially over time. MySQLs bulk Insert or Update syntax is one of those techniques.

MySQL Sales Reporting by Holiday

MySQL Sales Reporting by Holiday

Not all real-world reporting requirements align well with how your data is organized. In my case, I had to produce sales reports tied to a US Holiday (which varies year-to-year).

Fun with SQL Injection

Fun with SQL Injection

There are dozens of different ways to be a victim of an SQL injection attack. This article offers a more example-driven approach to learning about SQL Injection and how to avoid it.