Please briefly describe the basic format of SQL statements

select

from[Table name].

where[condition].

select*fromtable, which is the most basic and commonly used.

Structured Query Language (StructuredQueryLanguage) is abbreviated as SQL (pronounced: eskju el"s-q-l"), a special-purpose programming language, is a database query and programming language for accessing data and querying, updating, and managing relational database systems; It is also an extension for database script files.

The Settlement Prestructured Query Language is a high-level, non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the method of data storage and loss, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Structured Query Language statements can be nested, which makes it extremely flexible and powerful.

In October 1986, the American National Standards Institute standardized SQL as the standard language for relational database management systems (ANSI).

In 1987, it became an international standard with the support of the International Standards Organization. However, various common database systems have made some modifications and extensions to the SQL specification in the process of their practice. Therefore, in fact, the SQL between different database systems cannot be used in general.

SQL Select statement.

The select statement is used to pick up data from the database. The results are stored in a results table, called a result set.

SQL Select syntax.

select column_name from table_name;

For example: select * from users;

Here's a concrete example:

from shulanxt

The simplest is select [column name] from [table name] where [condition]. Then you can add something like limit to the end; order by；group by and so on. Choose by yourself according to different conditions.

select

from[Table name].

where[condition].

select*fromtable, which is the most basic and commonly used.

You can see it here.