Don’t Emulate Prepared Statements with PDO & MySQL
Recently I have been updating one of my older sites to a completely new code base, and with that new code I’ve switched all old MySQL calls from the old mysql_* functionsRead More…
Tag Archives: Database
05Mar/14
ORA-01745: Invalid host/bind variable name error
I had a simple query where I was pulling data on a user, but binding with :user, as in select * from user_table u join other_table o on u.user_id = o.user_id whereRead More…
17Apr/13
Moving Data from MS Access to MySQL
Just recently the library at the school where I work asked me to write a web application so that they could more easily manage their electronic resources. The resources they were trackingRead More…
08Apr/13
MySQL and JSON
I just ran across this post (via Planet Mysql) at Flite Mechanics. Apparently you can now use common_schema to parse JSON directly. Now there’s no more need to run your JSON throughRead More…
18Jan/13
Scaling MySQL
Here’s an interesting tutorial about Scaling MySQL for Developers that I ran across at Johathan Levin’s blog. It touches on indexing, troubleshooting, and table optimization, as well as a lot more, butRead More…