pf » Tag: select on Pete Freitag's Blog

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.

If you have ever had to do lots of SQL INSERT statements you will know that they can get pretty slow. When looking for ways to speed up some inserts, I noticed that you can use a SELECT subquery to provide the values.

Seth Godin has a great post called The persistence of really bad ideas, in which he rants about how web developers always seam to use select boxes for picking states and countries:

There are fifty states. This is a problem.