Common MySQL Queries

William Estep
Programming
September 10, 2013

Table of Contents

I ran across this terrific resource, Common MySQL Queries.

Tons of great examples…for example:

Given a birthdate in @dob, here are two simple formulae for age in years:

Date_format( From_Days( To_Days(Curdate()) - To_Days(@dob) ), '%Y' ) + 0
Year(Curdate()) - Year(@dob) - ( Right(Curdate(),5) &amp;lt; Right(@dob,5) )

and here is one for age in years to two decimal places, ignoring day of month:

Round((((Year(now()) - Year(@dob)))*12 + (((Month(now()) - Month(@dob)))))/12, 2)

Enjoy!

WOTD: Gonfalon

A Gonfalon is a type of flag or banner suspended from a crossbar.

"The Body Myth: Adult Women and the Pressure to be Perfect" by Margo Maine, Joe Kelly

Reviewer: Linda

While this is not the most well-written book I have read, it is thought provoking. Aimed generally at eating disorders that cause women to starve themselves (anorexia or bingeing and purging) it has some applicability to anyone with an eating disorder. The book concentrates mostly on the media and the “body myth” from there, i.e., all women should look like teenager boys but with big boobs.