How about 'Everything You Must Know About MySQL'

"Must Know MySQL" focuses on practicality and is highly operable. It is suitable for learning reference for the majority of software developers and database managers.

About the author

BenForta, a world-renowned technical writer, is also the most well-known in the Adobe technology community One of the experts, currently serves as a senior technical promotion expert at Adobe. He has more than 20 years of working experience in the computer industry and has written more than a dozen technical books over the years, including "Must Know and Must Know Regular Expressions", "Must Know and Must Know SQL" (published by People's Posts and Telecommunications Press) and other world-wide bestsellers , has been translated into more than a dozen languages.

Recommended courses: MySQL Tutorial.

Editor recommendation

As a representative of open source software, MySQL has become one of the most popular database management systems in the world.

"Must Know and Must Know MySQL" is written by the author at the request of many readers after the classic bestseller "Must Know and Must Know SQL", specifically for MySQL users. "Must Know MySQL Must Know" inherits the advantages of "Must Know SQL Must Know". It does not elaborate too much on the basic theory of database, but closely follows the actual needs. It starts directly from data retrieval and gradually deepens into various complex contents, including The use of joins, subqueries, regular expressions and full-text based searches, stored procedures, cursors, triggers, table constraints, and more. Through "MySQL Must Know, Must Know", readers can master solid basic skills and quickly become MySQL masters.

A new work by the author of "Must Know SQL", with a full five-star rating on Amazon, suitable for both study and reference.

"Must Know MySQL": A portable manual and introductory book for MySQL

Recommended for people who have no knowledge of MySQL to read it to establish basic concepts, and have almost the same knowledge about MySQL that I learned in college Those who have lost everything quickly regain the basics.

This book basically covers the knowledge points that you need to know about MySQL, but for each point it is mainly practical, explaining the basic usage, not going into the principles, but more giving a way.

I think this book is more like a panoramic map, allowing novices to have a bird's eye view of the whole situation, and at least know where to go in-depth when they have a certain problem.

The previous chapters are actually quite practical, but I think the advanced content chapters are too simple, and even the concepts and practical application scenarios are not well explained (but this is the positioning of this book itself) limitations), it is necessary to read some more in-depth books after the beginning of this chapter on stored procedures.

Due to checking for gaps in my own knowledge, I read and took notes on the chapters starting with Chapters 1 and 2, full-text search, and view. On the one hand, I basically understand the core part of SQL in the middle. On the other hand, I don’t know how to write “raw query” in actual coding now. It is more left to ORM to solve, so I didn’t take a closer look.

The above is the detailed content of How about 'Everything You Must Know About MySQL'. For more information, please follow other related articles on the PHP Chinese website!