[MySQL] Any "advanced" books out there?

feenster99 · 31 Jan 2006 at 08:04

Hi folks,
I've been using MySQL for a couple of years now, but I feel I am only scratching the surface of what I need to know. I would like a book (or online tutorials i guess) that will walk me through some of the more advanced topics such as triggers, query optimisation, full text query, indexes, etc (and hopefully, views and stored procedures in V5).

Can anyone recommend me any decent books or URL's?

Cheers,
Matt

Sparky191 · 31 Jan 2006 at 08:40

I'm in the same boat myself.

happytechie · 31 Jan 2006 at 10:44

are you looking at specific MySQL refernce info or more generic database design technigues? Personally I'd lookat building a DB and putting some triggers in. simple pre-update validation triggers (say to check that a postcade matches an address ans post-update triggers (to update othe rtables when a primary table is updated) are easy to design and implement. Prcatice is the only way to become highly skilled at database design and implementation imo. I can probably offer you some links to generic DB design stuff but my MySQL knoledge is zero

HT

HT

feenster99 · 31 Jan 2006 at 19:08

HT - thanks for the reply. I did quite a bit with SQL Server, so have knowledge from there. I was really aiming for stuff specifically aimed at MySQL as that is what I work with on a daily basis now.

Matt