Trying to add a POLYGON using GeomFromText? I don't know about you, but although it's documented as being able to "construct a geometry value of…
MySQL full text search w/ relevance percentage
We're using an FAQ table below, to demonstrate how to return a result set that includes the keyword relevance as a percentage of the maximum…
Make those SQL queries chunky
I'm by no means saying that my tests below are evidence enough to support the case for "chunky" SQL queries. By chunky, I mean queries…
MySQL Duplicate Key issues
So you're doing a bulk import into your MySQL database, knowing that your primary key values are unique. Yet, MySQL throws the Duplicate Key message…
ColdFusion / JDBC / MySQL & VarBinary fields
If you've used a varbinary field to store data, such as an encrypted password, you mind find that the JDBC Connector (used by ColdFusion) falls…
Bulk inserts to reduce trips to database
By combining multiple inserts into one bulk insert statement, you can reduce the total number of statements sent to the database, speeding up combined execution…