There may be several incoming messages. The number of requests depends on the server, network, and goals. What happens in the MySQL environment: The system creates a table to store data (sort it, identify it, and do other operations). Other participants in the relationship – clients – try to obtain this information using SQL commands. There is also a third party – a server application that receives a request from the client, processes it and gives it a response.
To send commands to the MySQL server, you ne to know the appropriate utilities
Some of them are sent via the command line, others via the graphical interface. Advantages and Disadvantages of MySQL MySQL is not the rich people number data only database management system, but it is one of the most popular. Due to its versatility, it is us in the development of websites, web applications and corporate databases. Strengths MySQL is convenient to work with, because it has several advantages: Reliability.
The DBMS has been on the server software
Market for a long time and has establish itself as a technology that can be trust with critical business applications. Scalability. MySQL is us not only email automation for beginners: Part 1 by novice users, but also by entire corporations. Performance: Tests have shown that MySQL is faster than other database services. Uninterruptible operation. MySQL has a built-in solution for disaster recovery. Ease of use. MySQL is easier to learn than professional DBMS.
Weaknesses The technology also has its drawbacks:
Possible occurrence of instability; may slow down when multitasking; does not support patches from independent developers; has a ne to install extensions. Who ne s this? Anyone who develops websites and web applications cannot do without buying house b knowl ge of MySQL or another DBMS. After all, it is impossible to imagine a project that involves the presence of personal user accounts, various catalogs, content of different types and other data, and at the same time stores all the information without sorting and structuring.