好的MySQL底层/学习资源 [英] Good MySQL primer / learning resources
问题描述
任何人都可以指点我的MySQL数据库构建的一些好的最佳实践文档的方向？我已经编写了很多年了，熟悉MySQL的一些基础知识（虽然我的编码经验中没有涉及数据库工作），但我想刷新我的知识。
Can anyone point me in the direction of some good 'best practices' documents for MySQL database construction? I've been coding for a number of years now and am familiar with some of the basics of MySQL (although most of my coding experience hasn't involved DB work) but I'd like to brush up on my knowledge.
如果任何人可以指出任何中级文件，这可能会很好，它涵盖了我可能错过的一些基本知识，同时不怕显示
It would be great if anyone can point me at any middle level documents which cover some of the basics I may have missed whilst at the same time aren’t afraid of showing 'the way it should be done' and, most importantly, why.
谢谢！
推荐答案
我就像你：编码了一段时间，但没有DB经验;我不得不自己学习MySQL。
I'm like you: coding for a while, but no DB experience; and I had to learn MySQL on my own.
我找不到你想要的书，虽然我买了（几个）。
I could not find the book you're looking for, though I bought (quite) a few. I finally just dove in and started trying stuff.
看到，MySQL可以这么复杂 - MySQL语句可以有这么多的排列 - 这是不可能找到只是简单，食谱类型的例子在任何书。但是，很容易开始使用简单的SELECT语句，并自己移入更强大，更强大的语句。
See, MySQL can be so complex -- MySQL statements can have so many permutations -- that it was impossible to find just straightforward, cookbook-type examples in any book. But it's easy to get started with simple SELECT statements and moving into more capable, powerful statements on your own.
我不能做到，来自MySQL论坛的帮助：
I could not have done it, though, without a whole bunch of help from the MySQL forum:
其中有一个子组只为您和我：
which has a subgroup made just for you and me:
< a href =http://forums.mysql.com/list.php?10 =nofollow> http://forums.mysql.com/list.php?10 ，或选择Newbies 从主论坛页面。
http://forums.mysql.com/list.php?10 , or select "Newbies" from the main forum page.
这些人是巨大的帮助和耐心：他们愿意带领我通过一些微妙和疯狂 MySQL文档的不一致。
These folks are tremendously helpful and patient: they were willing to lead me through some of the subtleties and the insanities inconsistencies of the MySQL docs.
有人描述为MySQL圣经的书是 Paul DuBois，MySQL（第4版） [平装] ，这是另一个1200页的怪物门口，我不需要。我不推荐它：它在很大程度上是一个文档的重新安排，它没有教程，并且索引是不完整和纯粹的错误。我实际上一年前买了这本书，上个月就把它删除了。
The book that some describe as the "MySQL Bible" is Paul DuBois, MySQL (4th Edition) [Paperback], which is another 1200-page monster doorstop that I don't need. I don't recommend it at all: it's largely a rearrangement of the docs, it has no tutorial to speak of, and the index is incomplete and just plain wrong. I actually bought this book a year ago and got rid of it last month.
你会是一个很好的，因为我说，只是尝试自己的东西。
You'll be a lot better off, as I say, just trying stuff on your own.
我认为MySQL在C语言的复杂性和功能上是可比的;并且需要大约两三个月的时间来实现自给自足和有用的能力。
I think that MySQL is comparable in complexity and power to the C language; and it takes just about as long -- two or three months, say -- to become self-sufficient and usefully competent.
祝你好运！你会做的很好。
Good luck! You will do just fine.
这篇关于好的MySQL底层/学习资源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
