MySQL book recommendations
For my current job I need to do MySQL work -- Both designing new stuff and optimizing existing stuff, some operations take up to a minute to complete and stuff I'm writing at the moment might take even longer!
The tables have no keys or have keys that are never used, most columns are TEXT columns, and I suspect the queries in the code could be a lot better too.
I know enough about MySQL to know this, but to be honest I lack the in-depth experience/knowledge to fix this properly once and for all.
There are more pressing/urgent matter to be done at the moment, so I have a few weeks to brush up my MySQL.
Can anyone recommend a good book? I'm looking for something that will at least do a good (indepth) explanation of the basics (preferably while maintaining brevity and being to the point -- I am not an idiot).
UNIX was not designed to stop you from doing stupid things, because that would also stop you from doing clever things.