mysql为什么叫结构化查询语言？结构化是什么意思？

Question

结构化是什么意思？

Answer 1

Structure means that the data is structured. For example, Mysql is divided into fields, and each field has a type. The query is based on these fields.

Unstructured means that the data is text or binary without structure. For example, full-text search is an unstructured query

Answer 2

Mysql is a database, not a query language.

You are talking about sql (full name Structured Query Language) or SQL for short. Structured Query Language is an advanced non-procedural programming language that allows users to work on high-level data structures. It does not require users to specify the storage method of data, nor does it require users to understand the specific data storage method, so different database systems with completely different underlying structures can use the same statement.

Answer 3

Structured query language means that SQL statements have a structure, which can be imagined as fill-in-the-blank questions
Query statements

SELECT 字段 FROM 表 WHERE 条件 ORDER BY 排序条件 GROUP BY 分组条件 ...
UPDATE 表 SET 字段名=字段值 WHERE 筛选条件
DELETE FROM 表 WHERE 筛选条件