How to quickly and effectively master the database language MySql?

Find a set of database full set of tutorials, roughly go through it first, understand what problems this thing can solve, under what circumstances it will be used, and how to optimize, with these questions about it, learn the use of database management tools, it is definitely the fastest to get started, there is no one, you are lucky, I will start next week to update the use of mysql database and database management tools, some basic additions, deletions, modifications, checks, left outer joins, sorting, group queries, primary and foreign keys, indexes, etc. I hope it will be helpful to everyone, come on.

First of all, correct, the database is called mysql is completely ok, if you talk about the database language, it can only be called sql, mysql, oracle, sqlselver and so on are all following sql rules, where you want to speed is not reached, if you want to ask for speed in development, then your bug maintenance time is enough for you to bear, so if you don't understand the database in the early stage, it is recommended that you still work steadily. If you have to use it in a hurry, I can only give you this advice.

First of all, MySQL is not a database language, the database language is SQL, and generally follows the SQL 92 standard. The easiest way to learn any language is to do it. If you want to learn more deeply, you can use MysqlClient to link in and operate directly without a graphical interface.

Start by creating, modifying, and deleting a table. Then start the normal select, insert, update, and delete to start the practice, remember the syntax, and then when you are familiar with it, start the inner join, left join, etc. When you are familiar with the above, you can go to some ** question banks to brush up on the questions, generally there will be test data for you, and then give you a question, and finally you can complete the question requirements by writing SQL statements.

If you've learned how to use SQL Server, you've mastered the SQL language. If you want to learn more, you need to deeply understand the storage engine of MySQL, and develop system software that you can understand as MySQL SQL Server SQLLit3 Oracle are all based on the SQL language.

You need to understand what the purpose of learning MySQL is, whether it's for DBA or application development. If you want to do DBA, you need to spend a lot of energy, you need to understand the underlying principles, and you need to be constantly in the production environment. More problems are exposed on **.

First of all, I want to tell you that the three goals of speed, mastery, and mysql add up to achieve the goal. Eating fast food is okay, but it may cause indigestion.

I have never heard of this language, and I still need further study.

It's good if you're strong enough.