Tip: Impatient students can scan the QR code of this book directly to the end of this article.

First pull bullshit

He come! He come! That kid guy driving colorful clouds holding his new book “how to use MySQL: a quick start MySQL” toward everyone! Let’s show everyone what kids’ new books look like:

It’s still the cover of Kawaii, a child’s vision: sometimes we walk for so long that we forget why we set out. Similarly, adults when they grow up and forget the appearance of himself as a child, a technical expert know-how for beginners are faced with the problem is often unable to experience, so I decided to the perspective of children (beginner) to create some technical books, from the perspective of the user to solve the comrades are faced with the pain points in the process of learning.

Many years ago, children boasted that they wanted to build a computer book pyramid, so that their friends could happily learn from the bottom of the pyramid to the top of the pyramid. Imagine that at some point in the future, you will have dozens of computer books on your bookshelf. When you look at them, you will find that the authors are children 4919. It will be so beautiful

Now it has been 4 years since children left office, and the second paper book for children has finally come out, finally further from the dream 😂!

What is the difference between how MySQL works and How MySQL works

Kids published their first book, how MySQL Works: Understanding MySQL from the Ribs, in November last year. From the title, it can be seen that this book is talking about how MySQL works (feel like a nonsense 🤷♀️).

How MySQL Works is a nagging talk about how MySQL, as a piece of software, was designed to implement a database. To that end, we talked about the range of data structures needed to run MySQL, starting with the most basic record structure, going through page structure, index structure, and table space structure. I then talked about how to use these structures to execute queries and how MySQL performs these queries better (query optimization). Finally, the book talks about InnoDB’s introduction of redo logging, undo logging, MVCC, and transaction locking in order to implement transactions.

How MySQL works is written for those who have some programming experience and need to advance in the database. If a beginner comes up to read this book, in addition to their programming foundation is not very good, then nine out of ten is a face of meng force, a face of meng force.

So, how to Use MySQL: A Quick Start on MySQL was born! As the title suggests, it teaches beginners how to use MySQL. In addition, the word “fast” in the subtitle also emphasizes that this book is very easy to read, and people who have no programming experience can master the basic use of MySQL in a short time.

What are the features of this book

  • Hand-holding, nanny teaching. There is no skipping discussion, and it is a progressive teaching method step by step.

  • The full text is written in plain English, and some places are “bullshit”, just like a person talking with his classmates.

  • From a beginner’s point of view, avoid introducing a new concept with an unlearned one.

  • The structural division of layers of matting. The contents of this book form a closed loop, and I hope that after reading the book, you will have a feeling that you have read a complete story.

All in all, this is a simple, concise, fun, systematic book for beginners to learn MySQL syntax.

What is the book about

This book starts from the point of view of zero-based users and starts from the installation of MySQL according to their cognitive habits. Introduces the use of MySQL server program and client program, MySQL data types, database and table basic operations, column attributes, expressions and functions in MySQL, simple and complex add, delete, change, check statements and other MySQL syntax. It also introduces advanced concepts such as views, stored programs, backup and recovery, user and permission management, and the use of the Java language to connect to the MySQL server.

Below is the table of contents of this book.

The examples in this book were tested in MySQL 8.0.23.

The target audience of this book

  • Zero base user
  • Students who have learned some SQL but are not familiar with it
  • Those of you who want to have a handy reference book

After-sales service

I believe that most of the students buy books not only want to buy a few pages of paper (except some of the students who bought the collection of course), we buy books just want to buy the knowledge contained in the book, if not the knowledge, then what is the difference between the book and toilet paper (perhaps not as soft as toilet paper ~)?

Children think that mastering a skill requires only the following two aspects:

  • An enjoyable technical book to read.
  • Be ready to answer any questions you have.

In addition to being easy to understand, the biggest difference between this book and other books is that it provides q&A service. You can scan the QR code provided in the book to enter the Q&A group to ask questions directly to the author.

That is to say, this is a book that includes teaching and meeting, not to find children!

It is important to note that if you want to ask questions, you must first understand what you are not clear about, and then use a clear statement to express it. In the past, many students’ questions are vague and inarticulate. Such questions make people crazy. So for the convenience of both of us, please think carefully before asking questions.

As for the q&A service, the students who have bought “how MySQL works” and the children’s gold digging pamphlet have a good say (you can consult the students who have bought them around). In addition, I am only responsible for answering the questions about this book, please discuss other questions with other students (one is that the author probably can not, two is the author’s energy is limited, please understand).

How to Buy a Book

The price of the book is 59.9 yuan, children here to promote, JINGdong use 100 minus 50 promotion strategy, dangdang use direct 50 discount promotion strategy.

You can scan the following QR code to buy half price (be sure to buy through the following QR code oh, so the author can earn 1 yuan more)!

If you use JINGdong, please click to scan the QR code:

To use Dangdang, please click to scan the QR code:

conclusion

Children are in and will be in a state of quitting to concentrate on writing books for a long time. Everyone’s support is the motivation for children’s continuous creation (after all, children are not rich second generation, they also have to earn money to eat). Children will definitely create more easy-to-understand technical books to make everyone’s learning process easier and faster.

In addition to the MySQL series, what do you most want to read? Leave a comment below and maybe write about it in the next edition!