What is the SQL language a standard language about?

SQL language is the standard language for "relational database". SQL language is a special purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems.

The operating environment of this tutorial: Windows 7 system, mysql version 5.8, Dell G3 computer.

SQL language is the standard language for "relational database".

SQL language was proposed by Boyce and Chamberlin in 1974, and was first implemented on SystemR, a relational database system developed by IBM. Because of its outstanding advantages such as rich functions, convenient and flexible use, simple and easy to learn language, it is very popular among the computer industry and computer users. In October 1980, SQL was approved by the Database Committee X3H2 of the American National Standards Institute (ANSI) as the American standard for relational database languages. Standard SQL was announced in the same year. Shortly thereafter, the International Organization for Standardization (ISO) also made the same decision. .

SQL language integrates data query, data manipulation (DML), data definition (DDL) and data control (DCL) functions, fully embodying the characteristics and advantages of relational database language. Its main features include:

• Comprehensive and unified. The SQL language integrates the functions of data definition language (DDL), data manipulation language (DML), and data control language (DCL), with a unified language style.

• Non-procedural. When using SQL language to perform data operations, users only need to ask "what to do" rather than "how to do it".

• Collection-oriented operation mode. The SQL language uses a set operation method. Not only can the search result be a collection of tuples, but the object of an insertion, deletion, and update operation can also be a collection of tuples (one collection at a time).

• Provides two usage methods with the same syntax structure. The SQL language is both a self-contained language and an embedded language. As a self-contained language, it can be used independently for online interaction. Users can directly enter SQL commands on the terminal keyboard to operate the database. As an embedded language, SQL statements can be embedded into high-level language (such as C, COBOL, FORTRAN) programs.

• The language is concise, easy to learn and use.

For more related articles, please visit: mysql video tutorial

The above is the detailed content of What is the SQL language a standard language about?. For more information, please follow other related articles on the PHP Chinese website!