httpremix.com

About the Author

Jonah Ellison lives in Seattle, Washington and works at a web firm developing websites and custom web applications for the LAMP solution stack. He enjoys optimization, front-end usability, databases, clean code and clever solutions. Contact him or learn more.

 

Topics

ArchiveSearch Results

MySQL Subqueries and INNER JOINs 2009 Apr 3

Topics: mysql — by jonah ellison

Two advanced MySQL tips today:

  1. Never use a subquery inside a WHERE field IN(…) list

  2. How-to: Update values in a table from a calculation that uses the table’s own values, in a single query

(Read more…)