为什么大部分互联网公司，使用的数据库都是MySQL？

Well... MySQL... Why do Internet companies use it...
The main thing... open source... free... This is very important.你看……2 02 2 年……如果你选择Oracle……或者微软的MSSQL……在你的公司建立一个数据库，你就得花钱……每年多少钱……可能几万……甚至几十万……对于初创公司……尤其是小公司……那笔钱……压力太大了。
I realized later... MySQL just doesn't have that level of fees... just use it... and save.
Then... PHP... this language... was very popular at that time... simple... easy to learn. Many programmers... especially those new to the industry... will use PHP. MySQL and PHP... ah... they work very well together... and are very efficient. You see, WordPress... that CMS... DreamWeaver... are all built using these two. A large number of websites...all use it this way...and it has formed a habit...You can't change it even if you try to change it.
One more thing... Linux... Internet servers... Most of them are installed with Linux... Stable... Secure... And energy saving. This architecture is LAMP... L - Linux... N - Nginx or Apache... A - Apache... M - MySQL... P - PHP... It has MySQL. The whole ecology... is quite mature.使用 MySQL 的 LNMP 也是如此。
Once you get used to it... operation and maintenance will also become convenient.
另外...许多公司...无法创建自己的数据库...所以他们购买现成的程序...例如WordPress...Empire CMS...他们...默认都使用MySQL...您只需安装它...您不必担心如何设置数据库...这消除了麻烦。
这……惯性……太强了。

MySQL itself... is not complicated... installation and configuration... relatively simple. For small to medium sized data... its performance is ok. Community... There are a lot of questions... Someone can answer them... It's very convenient. Unlike some commercial databases...they are difficult to learn...and not easy to manage and maintain.
所以...总结...MySQL...免费...环保...易于使用...每个人都使用它...并且它已成为首选。
Perhaps... large companies... or those who especially need安全性...需要高性能...可以考虑其他选择...但对于大多数企业...MySQL...就足够了。

mysql是什么类型的数据库

MySQL，这个东西是做什么的？关系数据库，RDBMS。
To put it bluntly, tables are used to store data. You see, the data is divided into many tables, not all grouped into one h3 table.
核心是如何设计的？数据被分割并归档。
For example, there is one table for user information and another table for order information.为什么这么干净？ To reduce duplication, save each user's information in the order table. It is much faster to save, check and edit data this way.它也很容易扩展。
添加表格非常简单。
I saw a project where using this design made the query speed much faster than before.
背景是什么？它来自 Oracle，但现在是开源的。
It uses SQL language to operate, this language is familiar to everyone. It can run on Windows and Linux, which is quite flexible. There is a free community version and a paid commercial version. Many small and medium-sized businesses prefer the community version to save money.
How is MySQL better than using files directly to store data?指数优化、交易管理。
It can handle large amounts of data, has high reading and writing efficiency, and the data can be kept consistent. You see, systems like banks have high data consistency requirements, so they have to use this type of system.
What are the characteristics of relational databases? Data structuring consists of using two-dimensional tables. A table is made up of rows and columns, the rows are records and the columns are fields. For example, the user table has columns like ID, name, and age.
The relational model is linked by primary keys and foreign keys. Like the user ID in the orders table, you can find the corresponding ID in the users table. Standardized support, following ACID principles to ensure reliable transactions.起初我不明白为什么这四个要素是必要的，但后来在做这个项目的过程中，我意识到它们实际上非常重要。

在哪里使用它？常用于网页开发。
在LAMP技术栈中，MySQL是核心。
Lightweight and suitable for a variety of projects. The open source community also provides many good things, such as the InnoDB storage engine, which supports transactions. E-commerce and content management systems are all inseparable from it.

mysql数据库是什么

上周，我朋友的公司刚刚升级了他们的数据库系统，他们选择了MySQL。
他说这个数据库确实不错，支持很多操作系统，比如Linux、Windows，而且效果非常强。

2 02 3 年，我了解了MySQL的历史，蛮有趣的。
它最初由瑞典公司MySQLAB开发，后来被Sun Microsystems收购，后来由Oracle管理。
尽管有人担心对市场的影响，但MySQL仍然是很多人心目中的首选。

我的一个朋友提到MySQL的交叉兼容性是他在他的平台上最喜欢的。
可以用C语言编写程序，然后用Python调用数据库。
这实在是太合适了。
另外，MySQL非常擅长工作，可以处理大量数据。

他还表示MySQL足够灵活，可以独立部署，也可以集成到其他程序中。
另外，它还支持多种文字，例如中文GB2 3 1 2 ，这对于国际化应用来说是一个很大的优势。

谈及应用场景，朋友说Web开发中最常见的是MySQL。
例如，LAMPS中的“M”是MySQL架构。
就连Google和Facebook在早期也使用过MySQL。

在版本方面，他告诉我MySQL有社区版和活动版。
社区版是免费的，适合个人开发者或开源项目。
企业版提供更高级的功能和收费的技术支持。

我的朋友最后说，虽然Oracle的接受导致一些开源狂热分子转向MariaDB，但MySQL仍然是一个稳定、低成本、活跃的数据库社区，在全球范围内非常受欢迎。