Oracle、MySQL、达梦数据库保留字问题对比

DM:8.1.3.26

SELECT JOB,SCHEMA_USER,LAST_DATE,LAST_SEC,NEXT_DATE,FAILURES,INSTANCE,INTERVAL FROM DBA_JOBS;

SQL> SELECT INTERVAL FROM DBA_JOBS;SELECT INTERVAL FROM DBA_JOBS;
SELECT INTERVAL FROM DBA_JOBS;               *              第 1 行, 第 16 列[FROM]附近出现错误[-2007]:语法分析出错.已用时间: 0.274(毫秒). 执行号:0.

SELECT * FROM DBA_JOBS;

SELECT "INTERVAL" FROM DBA_JOBS;

SQL> SELECT `INTERVAL` FROM DBA_JOBS;SELECT `INTERVAL` FROM DBA_JOBS;
SELECT `INTERVAL` FROM DBA_JOBS;      *                         第 1 行, 第 7 列[`]附近出现错误[-2007]:语法分析出错.已用时间: 0.235(毫秒). 执行号:0.

SQL> SELECT 'INTERVAL' FROM DBA_JOBS;行号     'INTERVAL'---------- ----------1          INTERVAL2          INTERVAL
已用时间: 0.456(毫秒). 执行号:5245214.

一.达梦保留字转义方法有哪些？二.达梦数据库自带的系统表保留字查询时也需要特殊处理吗？三.Oracle、MySQL数据库是否有类似情况？

https://eco.dameng.com/community/article/6ca6b591fecb40d2941e524af5fc25c9作者：LeeWen

SELECT "INTERVAL" FROM DBA_JOBS;

EXCLUDE_RESERVED_WORDS：

sp_set_para_string_value(2,'EXCLUDE_RESERVED_WORDS','xxx');

KEYWORDS=(xxx,yyy.zzz)

jdbc:dm://192.1.1.100:5236/CJC?keywords=(xxx,yyy,zzz)

SELECT "INTERVAL" FROM DBA_JOBS;

SQL> col interval for a30SQL> select INTERVAL from dba_jobs where rownum<=2;INTERVAL------------------------------sysdate + 8/24sysdate + 10/1440

set pagesize 1000set line 300col owner for a30select owner,table_name,column_name from dba_tab_columns where column_name='INTERVAL';OWNER                          TABLE_NAME                     COLUMN_NAME------------------------------ ------------------------------ ------------------------------SYS                            ALL_PART_INDEXES               INTERVALSYS                            DEFSCHEDULE                    INTERVALSYS                            DBA_JOBS                       INTERVAL......37 rows selected.

SET PAGESIZE 2000SELECT ROWNUM,KEYWORD FROM V$RESERVED_WORDS WHERE RESERVED='Y';......

SET LINE 300SET PAGESIZE 3000COL OWNER FOR A10SELECT OWNER,TABLE_NAME,CLOUMN_NAME FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME IN (SELECT KEYWORD FROM V$RESERVED_WORDS WHERE RESERVED='Y');

SELECT MODE FROM SYS.V$_DIAG_VHM_RUN where rownum<=1;ORA-00936:missing expressioin

SELECT "MODE" FROM SYS.V$_DIAG_VHM_RUN where rownum<=1;

SELECT RESERVED,WORD FROM INFORMATION_SCHEMA.KEYWORDS WHERE WORD='INTERVAL';

mysql> SELECT ROW_NUMBER() OVER(ORDER BY WORD) as ROW_NUM,WORD FROM INFORMATION_SCHEMA.KEYWORDS WHERE RESERVED=1 ORDER BY 2;......262 rows in set (0.00 sec)

mysql> alter table t1 add  INTERVAL int;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERVAL int' at line 1

mysql> alter table t1 add  `INTERVAL` int;Query OK, 0 rows affected (0.09 sec)Records: 0  Duplicates: 0  Warnings: 0

mysql> select `INTERVAL` from t1;

mysql> select 'INTERVAL' from t1;mysql> select "INTERVAL" from t1;