Thread

Hello there,

I’m getting interested in the intrinsics of MySQL and using the Query module.

Any suggestions on a good book or site to teach me about MySQL code?

Thank you all

I like this site:
http://www.tizag.com/mysqlTutorial/

I think the easiest thing to do is give yourself a simple task and figure out how to write the query for it.

Do a search for Query on the forums and in the Wiki and read what you find.

My feeling is that if you are just writing queries for EE and not trying to learn SQL in general, there isn’t a lot you need to learn about SQL, mostly you need to spend time understanding EE’s database structure.  Categories and related entries in particular can be brain rattling.

Depending on your skill level, you might find SQL for Mere Mortals a good book. The SQL isn’t strictly MySQL, but I find how it goes through complex queries a good thinking process.