mysql-front簡介

MySQL-簡介 (MySQL - Introduction)

什麼是數據庫？ (What is a Database?)

A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds.

數據庫是存儲數據集合的獨立應用程序。 每個數據庫都有一個或多個不同的API，用於創建，訪問，管理，搜索和複製其擁有的數據。

Other kinds of data stores can also be used, such as files on the file system or large hash tables in memory but data fetching and writing would not be so fast and easy with those type of systems.

也可以使用其他類型的數據存儲，例如文件系統上的文件或內存中的大型哈希表，但是使用這些類型的系統，數據的獲取和寫入將不那麼快捷，容易。

Nowadays, we use relational database management systems (RDBMS) to store and manage huge volume of data. This is called relational database because all the data is stored into different tables and relations are established using primary keys or other keys known as Foreign Keys.

如今，我們使用關係數據庫管理系統(RDBMS)來存儲和管理大量數據。 之所以稱爲關係數據庫，是因爲所有數據都存儲在不同的表中，並且使用主鍵或稱爲外鍵的其他鍵來建立關係。

A Relational DataBase Management System (RDBMS) is a software that −

關係數據庫管理系統(RDBMS)是一種軟件，該軟件-

• Enables you to implement a database with tables, columns and indexes.

  使您能夠使用表，列和索引來實現數據庫。

• Guarantees the Referential Integrity between rows of various tables.

  確保各種表的行之間的引用完整性。

• Updates the indexes automatically.

  自動更新索引。

• Interprets an SQL query and combines information from various tables.

  解釋SQL查詢併合並來自各個表的信息。

RDBMS術語 (RDBMS Terminology)

Before we proceed to explain the MySQL database system, let us revise a few definitions related to the database.

在繼續解釋MySQL數據庫系統之前，讓我們修改一些與數據庫有關的定義。

• Database − A database is a collection of tables, with related data.

  數據庫 -數據庫是具有相關數據的表的集合。

• Table − A table is a matrix with data. A table in a database looks like a simple spreadsheet.

  表格 -表格是包含數據的矩陣。 數據庫中的表看起來像一個簡單的電子表格。

• Column − One column (data element) contains data of one and the same kind, for example the column postcode.

  列 -一列(數據元素)包含一種相同類型的數據，例如列郵政編碼。

• Row − A row (= tuple, entry or record) is a group of related data, for example the data of one subscription.

  行 -行(=元組，條目或記錄)是一組相關數據，例如一個訂閱的數據。

• Redundancy − Storing data twice, redundantly to make the system faster.

  冗餘 -兩次存儲數據，以提高系統速度。

• Primary Key − A primary key is unique. A key value can not occur twice in one table. With a key, you can only find one row.

  主鍵 -主鍵是唯一的。 一個表中的鍵值不能出現兩次。 使用密鑰，您只能找到一行。

• Foreign Key − A foreign key is the linking pin between two tables.

  外鍵 -外鍵是兩個表之間的鏈接銷。

• Compound Key − A compound key (composite key) is a key that consists of multiple columns, because one column is not sufficiently unique.

  複合鍵 -複合鍵(複合鍵)是由多列組成的鍵，因爲一列不夠唯一。

• Index − An index in a database resembles an index at the back of a book.

  索引 -數據庫中的索引類似於書後部的索引。

• Referential Integrity − Referential Integrity makes sure that a foreign key value always points to an existing row.

  引用完整性 -引用完整性可確保外鍵值始終指向現有行。

MySQL數據庫 (MySQL Database)

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons −

MySQL是一種快速，易於使用的RDBMS，可用於許多大小企業。 MySQL由瑞典公司MySQL AB開發，銷售和支持。 由於許多原因，MySQL變得如此流行-

• MySQL is released under an open-source license. So you have nothing to pay to use it.

  MySQL是在開源許可證下發布的。 因此，您無需付費即可使用它。

• MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.

  MySQL本身就是一個非常強大的程序。 它處理最昂貴和功能最強大的數據庫程序包的大部分功能。

• MySQL uses a standard form of the well-known SQL data language.

  MySQL使用衆所周知SQL數據語言的標準形式。

• MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.

  MySQL可在許多操作系統上運行，並支持多種語言，包括PHP，PERL，C，C ++，JAVA等。

• MySQL works very quickly and works well even with large data sets.

  MySQL可以非常快速地運行，並且即使對於大型數據集也可以很好地運行。

• MySQL is very friendly to PHP, the most appreciated language for web development.

  MySQL對PHP非常友好，PHP是Web開發中最受歡迎的語言。

• MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).

  MySQL支持大型數據庫，一個表中最多有5000萬行或更多行。 表的默認文件大小限制爲4GB，但您可以將其增加(如果操作系統可以處理)，理論上可以達到800萬兆字節(TB)。

• MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

  MySQL是可定製的。 開源GPL許可證允許程序員修改MySQL軟件以適合他們自己的特定環境。

在你開始之前 (Before You Begin)

Before you begin this tutorial, you should have a basic knowledge of the information covered in our PHP and HTML tutorials.

在開始本教程之前，您應該對我們PHP和HTML教程中所包含的信息有基本的瞭解。

This tutorial focuses heavily on using MySQL in a PHP environment. Many examples given in this tutorial will be useful for PHP Programmers.

本教程着重於在PHP環境中使用MySQL。 本教程中給出的許多示例對於PHP程序員都是有用的。

We recommend you check our PHP Tutorial for your reference.

我們建議您檢查我們的PHP教程以供參考。

翻譯自: https://www.tutorialspoint.com/mysql/mysql-introduction.htm

mysql-front簡介