全部产品

FMT 模式 SQL 支持说明

更新时间:2021-02-09 15: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)

存储过程、触发器