plz suggest some name of book for learning MySQL .

[prismctg]

hi i m new in MySQL and database world .. so plz tell me some book name for learning MySQL :)

[codemaniac]

hi i m new in MySQL and database world .. so plz tell me some book name for learning MySQL :)

MySql Reference manual has everything you want .It would be somewhat hectic for a beginner though to swallow the whole at once .
http://dev.mysql.com/doc/

[prismctg]

thank you codemaniac (http://ubuntuforums.org/member.php?u=997189) :)

[SeijiSensei]

There are really two parts to this question. One concerns the operation and administration of the MySQL server itself. For that, the MySQL manual codemaniac cited is the obvious source.

However there's also the question of learning about the SQL language and the design of relational databases. For that a book like O'Reilly's Learning SQL (http://shop.oreilly.com/product/9780596007270.do) might be a better source.

Oh, and unless you're committed to MySQL for some specific reason, I'd consider using PostgreSQL (http://www.postgresql.org/) instead. It's closer to other "enterprise-class" SQL servers than MySQL and complies (http://www.postgresql.org/about/) closely with ANSI SQL standards. It's also not owned by Oracle if that matters to you (it does to me).