Getting Started with MySQL

Key points of learning MySQL

For PHP programmers, MySQL is to convert business into table structure. Do a good job of adding, deleting, modifying, and checking in the business.

If you don’t know what MySQL is, let’s introduce MySQL.

The MySQL database, referred to as MySQL, is a data management system developed by the Swedish MySQL AB company and widely used. The MySQL database is popular because of its small size, fast speed, and low total cost of ownership. Now, MySQL is owned by Oracle, the world's most famous database company.

The application of MySQL in domestic enterprises includes: Baidu, Alibaba, Tencent, Sina, Sohu, NetEase and other enterprises, all of which are using MySQL database.

MySQL is an open source relational database management system (RDBMS). The MySQL database system uses the most commonly used database management language - Structured Query Language (SQL) for database management.

Since MySQL is open source, anyone can download it under the GPL license and modify it according to personalized needs. MySQL has attracted much attention because of its speed, reliability and adaptability. Most people agree that MySQL is the best choice for managing content without transactional processing.

PHP is closely integrated with many databases. Because, PHP and MySQL are both open source and free. Therefore, PHP has always had good support for databases such as MySQL.

When we first learn PHP, we usually put the data in the MySQL database. Therefore, PHP programmers must learn courses for MySQL.

Many friends took many unnecessary detours in the early stages of learning MySQL, learned a lot of knowledge points that they did not need to master, and wasted a lot of valuable learning time.

When you first learn MySQL, you don’t need to learn the MySQL database and learn the level of a DBA (database administrator).

After writing code for two years. Many friends will encounter a bottleneck period. What strikes me the most is:

The most common things written in business code are addition, deletion, modification, and query.

In order to help you learn and get started quickly, I will help you summarize the best dry information. This chapter can be said to be a book: "Quick Start to the Essence of MySQL".

As long as you learn these contents, you will get started with mysql!

Learn to add, delete, modify, and check. I’m not afraid of writing business!

ps: You can imagine companies like Sina, Baidu, Sohu, etc. After some of the large companies use sharding, sharding, and database middleware technologies, are some of them not even allowed to use joint queries?