mysql简介_MySQL简介

mysql简介

MySQL is one of a number of popular website database solutions: other options include PostgreSQL and Firebird. The popularity of MySQL stems in large part from the fact that the database system both free and open source, and has strong community support. Most web hosting providers supply MySQL as the default database system for sites.

MySQL是许多流行的网站数据库解决方案之一：其他选项包括PostgreSQL和Firebird 。 MySQL的流行在很大程度上是由于数据库系统既免费又开源，并且具有强大的社区支持。 大多数Web托管提供商都将MySQL作为站点的默认数据库系统。

MySQL (pronounced either as “My SQL” or “My Sequel”) was developed by Ulf Michael (“Monty”) Widenius and David Axmark. “SQL” stands for Structured Query Language, the language in which its databases and tables are created, modified, and manipulated; the “My” is for Michael’s daughter. While the company originally formed to promote MySQL has undergone several mergers and acquisitions, and while there is a commercial version of MySQL available (used in high-demand sites such as Wikipedia, Facebook, Google, Flickr and Twitter), the open-source version is free, and always will be.

MySQL(由“ My SQL”或“ My Sequel”发音)由Ulf Michael(“ Monty”)Widenius和David Axmark开发。 “ SQL”代表结构化查询语言，即用于创建，修改和操纵其数据库和表的语言； “我的”是给迈克尔的女儿的。 虽然最初为促进MySQL成立的公司已经进行了多次合并和收购，并且有可用MySQL商业版本(用于Wikipedia，Facebook，Google，Flickr和Twitter等高要求站点)，但开源版本是免费的，而且永远都是。

There are many tools for interacting with MySQL data, including the MySQL Workbench for Windows, Mac and Linux, but the most common encountered by web developers is phpMyAdmin, which is built into many web hosting packages and servers.

有许多用于与MySQL数据进行交互的工具，包括适用于Windows，Mac和Linux的MySQL Workbench ，但Web开发人员最常遇到的是phpMyAdmin ，它内置在许多Web托管程序包和服务器中。

数据库和电子表格之间有什么区别？ (What’s the Difference Between Databases and Spreadsheets?)

While they appear the same – both use rows and columns, both record data in cells – that similarity is superficial. Database systems are designed to be used by many people with different levels of access at the same time (some people having the ability to only read from the database, others able to both read and write data); spreadsheets, in general, are only used by one person at a time.

尽管它们看起来相同(都使用行和列，但都在单元格中记录数据)，但相似之处只是肤浅的。 数据库系统旨在供具有不同访问级别的许多人同时使用(有些人只能从数据库中读取数据，而其他人则可以读取和写入数据)； 通常，电子表格一次只能由一个人使用。

One of the primary advantages of SQL languages is that simple database queries are written in a very human-readable way. For example:

SQL语言的主要优点之一是，简单的数据库查询以非常易于理解的方式编写。 例如：

SELECT * from camels where humps = 2 ORDER BY species

In this case, the query could be translated as “Select everything from the camels table that has a value of 2 in the humps field and provide the result in alphabetical order using the species field.”  As a result, Bactrian camels would be listed first (not that there are any other surviving two-humped camel species).

在这种情况下，查询可以翻译为“从选择一切camels已在值为2台humps场，并提供结果，用字母顺序species场”。 结果，双峰驼将被列为第一名(而不是还有其他两个幸存的驼峰物种)。

数据库作为语言 (Database-as-language)

One aspect of MySQL that can be confusing at first but valuable once grasped is that the language is the database; every action taken with the database is written in MySQL, as is the database itself. (Take a look at some of the printouts of the MySQL activity as you press buttons in phpMyAdmin, for example, or read an exported MySQL database as text).

MySQL的一开始可能会令人困惑，但一旦掌握就很有价值，它的一面就是语言是数据库。 与数据库本身一样，对数据库执行的每个操作均以MySQL编写。 (例如，当您按下phpMyAdmin中的按钮时，查看MySQL活动的一些打印输出，或者以文本形式读取导出MySQL数据库)。

翻译自: https://thenewcode.com/422/Introduction-to-MySQL

mysql简介