Home  >  Article  >  Database  >  What are the core statements of SQL?

What are the core statements of SQL?

青灯夜游
青灯夜游Original
2021-01-30 15:35:276437browse

The core statement of SQL language is: SELECT statement, which is used to select data from the table. The full name of SQL is Structured Query Language (Structured Query Language), its core is data query, and its query language has only one, namely SELECT statement.

What are the core statements of SQL?

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

The core statement of SQL language is: data query SELECT statement, which is used to select data from the table.

The data in the database is often for query, so data query is the core operation of the database. In SQL, there is only one query language, which is the SELECT statement.

The SELECT statement can be used to query and select data; the results are stored in a result table, called a result set. Querying data refers to using different query methods to obtain different data from the database according to needs. It is the most frequently used and important operation.

SQL SELECT syntax

SELECT column_name,column_name
FROM table_name;

and

SELECT * FROM table_name;

Extended information:

Structured Query Language (Structured Query Language) referred to as SQL , a special-purpose programming language, is a database query and programming language used to access data and query, update, and manage relational database systems.

Functions of SQL language:

SQL has the functions of data definition, data manipulation and data control.

1. SQL data definition function: Able to define the three-level schema structure of the database, namely external schema, global schema and internal schema structure. In SQL, the external schema is also called View, and the global schema is referred to as Schema. The internal schema is automatically implemented by the system based on the database schema, and generally does not require user intervention.

2. SQL data manipulation functions: including data insertion, deletion and modification of basic tables and views, especially strong data query functions.

3. SQL data control function: mainly controls user access rights to ensure system security.

For more related articles, please visit: mysql video tutorial

The above is the detailed content of What are the core statements of SQL?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn