Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Tutorial that teaches simple to complex mysql queries

Tags:

sql

mysql

I've used sql server previously, and want to master mysql.

Is there a tutorial that goes into more of the advanced type queries? It would be great if it was starting from simple and then made its way to teaching advanced queries and query optimizations etc.

If there is a book then please mention that.

thanks!

like image 862
Blankman Avatar asked Jun 15 '11 10:06

Blankman


2 Answers

Here's a list of common queries, this might help:
http://www.artfulsoftware.com/infotree/queries.php?&bw=1272

like image 150
wlk Avatar answered Sep 26 '22 06:09

wlk


Have a look at O'Reilly's SQL Cookbook. I own a copy of this and has been pretty handy.

like image 32
Sathyajith Bhat Avatar answered Sep 23 '22 06:09

Sathyajith Bhat