全部产品
云市场

FMT 模式 SQL 支持说明

更新时间:2020-03-16 12:53:45

  • 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)
存储过程、触发器