mysql
A case for CASE in your SQL
I’m going to add more to this later, but for now… SQL CASE scenario #1 Ever wanted to offer quantity discounts for shoppers? Here’s an example of a trivial implementation of the CASE condition in MySQL to get the job done. mysql> SET @cart_quantity := 3; Query OK, 0 rows affected (0.00 sec) mysql> select [...]
How to – LIKE – use prepared statements
I was going to do the whole Valley Girl theme for this post, but decided that was lame. So while converting an internal application query into a user-input web query when I stumbled across a problem. My prepared statement was not throwing an error and not giving me results. It took me a while to [...]
MySQL Conference 2009
A fast way to grow your skills The 7th annual MySQL Conference & Expo, co-presented by Sun Microsystems, MySQL and O’Reilly Media. Happening April 20-23, 2009 in Santa Clara, CA, at the Santa Clara Convention Center and Hyatt Regency Santa Clara, brings over 2,000 open source and database enthusiasts together to harness the power of [...]
