SELECT

语句用于从 TiDB 读取数据。

SelectStmt:

FromDual:

WhereClauseOptional:

SelectStmtOpts:

SelectStmtFieldList:

TableRefsClause:

WhereClauseOptional:

SelectStmtGroup:

HavingClause:

OrderByOptional:

FirstOrNext:

FetchFirstOpt:

RowOrRows:

SelectLockOpt:

WindowClauseOptional

Query OK, 0 rows affected (0.11 sec)

Records: 5  Duplicates: 0  Warnings: 0

+----+----+
| id | c1 |
+----+----+
|  1 |  1 |
|  2 |  2 |
|  4 |  4 |
|  5 |  5 |
+----+----+

SELECT 语句与 MySQL 完全兼容。如发现任何兼容性差异，请在 GitHub 上提交 。

• INSERT
• REPLACE