amilabandara/mysql-essencials.sql

Created February 11, 2015 09:35

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/amilabandara/00ecc35f51902c1a67ce.js"></script>
Save amilabandara/00ecc35f51902c1a67ce to your computer and use it in GitHub Desktop.

Download ZIP

mysql Essentials

Raw

mysql-essencials.sql

	#get age to current date
	select timestampdiff(YEAR, dob, curdate()) AS age from table name

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment