FMT 模式 SQL 支持说明

更新时间: 2023-07-26 16:21:27

SQL 语句的支持范围还在不断扩大,本文将介绍目前 SQL 语句的支持情况。

  • FMT 模式支持 SELECT、INSERT、UPDATE、DELETE 四类 DML 语法的部分功能。

  • FMT 模式不支持存储过程、触发器。

SQL 语句的支持范围还在不断扩大,目前 SQL 语句的支持情况如下:

说明

如果需要使用其它 SQL 语句,请在控制台 提交工单 咨询。

基本 SQL 语句

类型

SQL 实例

是否支持

INSERT

INSERT INTO tb1 (col_name,…) VALUES ({expr,value},…)

INSERT INGORE

INSERT INGORE INTO tb1 (col_name,…) VALUES ({expr,value},…)

INSERT … ON DUPLICATE KEY UPDATE

INSERT INTO tb1 (col_name,…) VALUES ({expr,value},…) ON DUPLICATE KEY UPDATE SET col1=expr1 [, col2=expr2 …] [WHERE where_definition]

UPDATE

UPDATE tb1 SET col1=expr1 [, col2=expr2 …] [WHERE where_definition]

DELETE

DELETE FROM tb1 [WHERE where_definition]

SELECT

SELECT select_expr, … FROM tb1 [WHERE where_condition] [order by condition] [group by condition [having condition]] [for update] [limit statement]

更新 SQL 语句

类型

SQL 实例

是否支持

AND & OR

UPDATE … WHERE col1 = expr1 AND col2 = expr2

LIKE

UPDATE … WHERE col1 LIKE ‘X%’

BETWEEN

UPDATE … WHERE col1 BETWEEN expr1 AND expr2

IN

DELETE … WHERE col1 in (expr1 ,…, exprN)

IS NULL

DELETE … WHERE col1 IS NULL

嵌套语句

UPDATE tb1 … WHERE col1 in (select col2 from tb2)

存储过程、触发器

SELECT 语句

类型

SQL 实例

读未提交

读已提交

AND & OR

SELECT * FROM tb1 WHERE col1 = expr1 AND col2= expr2

ORDER BY

SELECT col1, col2 FROM tb1 ORDER BY col1

GROUP BY

SELECT col1, col2 FROM tb1 GROUP BY col1 having col1 > 1

LIKE

SELECT col1, col2 FROM tb1 WHERE col1 LIKE ‘X%’

IN

SELECT col1, col2 FROM tb1 WHERE col1 IN (expr1, expr2,…)

BETWEEN

SELECT col1, col2 FROM tb1 WHERE col1 BETWEEN expr1 AND expr2

LIMIT

SELECT col1, col2 FROM tb1 LIMIT x

JOIN、INNER JOIN、LEFT JOIN、RIGHT JOIN、FULL JOIN

SELECT col1, col2 FROM tb1 JOIN tb2 ON tb1.col1= tb2.col2

UNION、UNION ALL

SELECT col1, col2 FROM tb1 UNION SELECT col1, col2 FROM tb2

嵌套查询

SELECT col1, col2 FROM tb1 where col1 in (select col3 from tb2)

存储过程、触发器

阿里云首页 金融分布式架构 SOFAStack 相关技术圈