devbox
我家小花儿
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

vue2 monoca-editor使用SQL：自动补全、自定义颜色、格式化代码、标记错误_vue项目中使用monaco-editor插件,代码补全怎么实现

作者：我家小花儿 | 2024-06-13 00:40:46

赞

踩

vue项目中使用monaco-editor插件,代码补全怎么实现

vue3 monoca-editor SQL：自动补全、自定义颜色、格式化代码、标记错误 

一、安装（注意webpack-plugin对应版本，否则不能运行）

参考 monaco-editor-webpack-plugin版本兼容

yarn add monaco-editor@0.29.1

yarn add monaco-editor-webpack-plugin@5.0.0 -D

二、配置vue.config.js

  1.  
  2. const MonacoWebpackPlugin = require('monaco-editor-webpack-plugin')
  3.  
  4. module.exports = {
  5.   configureWebpack: {
  6.     plugins: [
  7.       new MonacoWebpackPlugin({
  8.         language: ['sql']
  9.       })
  10.     ]
  11.   }
  12. }

三、使用

1.导入

  1. // 全局导入
  2. import * as monaco from 'monaco-editor'
  3.  
  4. // 局部导入需要的功能和依赖
  5. import * as monaco from 'monaco-editor/esm/vs/editor/edcore.main'
  6. import 'monaco-editor/esm/vs/basic-languages/sql/sql.contribution'

2.封装组件

基本框架

  1. <template>
  2.     <div id="code"></div>
  3. </template>
  4.  
  5. <script>
  6.   import Vue from 'vue'
  7.   import {Component} from 'vue-property-decorator'
  8.   import * as monaco from 'monaco-editor/esm/vs/editor/edcore.main'
  9.   import 'monaco-editor/esm/vs/basic-languages/sql/sql.contribution'
  10.   // import { language } from 'monaco-editor/esm/vs/basic-languages/sql/sql'
  11.   // language.keywords插件自带关键词的不全，网上找了一份自己维护
  12.   import sqlKeywords from './sqlKeywords.js'
  13.   @Component({
  14.     props: {
  15.       database: String
  16.     }
  17.   })
  18.  export default class SqlEditor extends Vue {
  19.     editor = null
  20.     color = null
  21.     suggestion = null
  22.     formatProvider = null
  23.  
  24.     mounted () {
  25.       this.initEditor()
  26.     }
  27.     // 父组件获取值
  28.     getValue() {
  29.       return this.editor.getValue()
  30.     }
  31.     // 父组件设置值
  32.     setValue(content) {
  33.       this.editor.setValue(content)
  34.     }
  35.     initEditor () {
  36.       this.editor = monaco.editor.create(document.getElementById('code'), {
  37.         //初始化配置
  38.         value: '',
  39.         theme: 'vs-dark',
  40.         autoIndex: true,
  41.         language: 'sql', // 语言类型
  42.         tabCompletion: 'on',
  43.         cursorSmoothCaretAnimation: true,
  44.         formatOnPaste: true,
  45.         mouseWheelZoom: true,
  46.         folding: true, //代码折叠
  47.         autoClosingBrackets: 'always',
  48.         autoClosingOvertype: 'always',
  49.         autoClosingQuotes: 'always',
  50.         automaticLayout: 'always'
  51.       })
  52.     }
  53.   }
  54. </script>

自定义提示

  1. databaseData = {
  2.   a: ['group', 'area'],
  3.   b: ['user', 'client']
  4. }
  5. tableData = {
  6.   user: ['age', 'gender'],
  7.    group: ['id', 'name']
  8. }
  9. // 关键字
  10. getSQLSuggest () {
  11.   return sqlKeywords.map((key) => ({
  12.     label: key,
  13.     kind: monaco.languages.CompletionItemKind.Keyword,
  14.     insertText: key,
  15.     detail: 'keyword'
  16.   }))
  17. }
  18. // 表名
  19. getTableSuggest (dbName) {
  20.   const tableNames = this.databaseData[dbName]
  21.   if (!tableNames) {
  22.     return []
  23.   }
  24.   return tableNames.map((name) => ({
  25.     label: name,
  26.     kind: monaco.languages.CompletionItemKind.Constant,
  27.     insertText: name,
  28.     detail: dbName
  29.   }))
  30. }
  31. // 字段名
  32. getParamSuggest (tableName) {
  33.   const params = this.tableData[tableName]
  34.   if (!params) {
  35.     return []
  36.   }
  37.   return params.map((name) => ({
  38.     label: name,
  39.     kind: monaco.languages.CompletionItemKind.Constant,
  40.     insertText: name,
  41.     detail: 'param'
  42.   }))
  43. }
  44. // 数据库名
  45. getDBSuggest () {
  46.   return Object.keys(this.databaseData).map((key) => ({
  47.     label: key,
  48.     kind: monaco.languages.CompletionItemKind.Enum,
  49.     insertText: key,
  50.     detail: 'database'
  51.   }))
  52. }
  53.  
  54. initEditor () {
  55.  
  56.       // 自动补全提示
  57.       this.suggestion = monaco.languages.registerCompletionItemProvider('sql', {
  58.         // 触发条件，也可以不写，不写的话只要输入满足配置的label就会提示；仅支持单字符
  59.         triggerCharacters: ['.', ' '],
  60.         provideCompletionItems: (model, position) => {
  61.           let suggestions = []
  62.           const { lineNumber, column } = position
  63.           const textBeforePointer = model.getValueInRange({
  64.             startLineNumber: lineNumber,
  65.             startColumn: 0,
  66.             endLineNumber: lineNumber,
  67.             endColumn: column,
  68.           })
  69.           const tokens = textBeforePointer.toLocaleLowerCase().trim().split(/\s+/)
  70.           const lastToken = tokens[tokens.length - 1] // 获取最后一段非空字符串
  71.           if (lastToken.endsWith('.')) {
  72.             // 提示该数据库下的表名
  73.             const tokenNoDot = lastToken.slice(0, lastToken.length - 1)
  74.             if (Object.keys(this.databaseData).includes(tokenNoDot)) {
  75.               suggestions = [...this.getTableSuggest(tokenNoDot)]
  76.             }
  77.           } else if (lastToken === '.') {
  78.             suggestions = []
  79.           } else if (textBeforePointer.endsWith(' ')) {
  80.             if (textBeforePointer.endsWith('select * from ')) {
  81.               // select * from 提示指定数据库的表名
  82.               suggestions = this.getTableSuggest(this.database)
  83.             } else if (lastToken === 'where') {
  84.               const lastToken2 = tokens[tokens.length - 2]
  85.               const lastToken3 = tokens[tokens.length - 3]
  86.               const lastToken4 = tokens[tokens.length - 4]
  87.               const lastToken5 = tokens[tokens.length - 5]
  88.               if (lastToken5 + lastToken4 + lastToken3 === 'select*from') {
  89.                 // select * from tableName where 提示指定表的字段名
  90.                 suggestions = [...this.getParamSuggest(lastToken2)]
  91.               } else {
  92.                 suggestions = []
  93.               }
  94.             }else {
  95.               suggestions = []
  96.             }
  97.           } else {
  98.             // 提示数据库名和关键词
  99.             suggestions = [...this.getDBSuggest(), ...this.getSQLSuggest()]
  100.           }
  101.           return {
  102.             suggestions,
  103.           }
  104.         }
  105.       })
  106. }
  107.  
  108.

 自定义文本颜色，自带也有

  1.  
  2. initEditor() {
  3.  
  4.       //自定义文本颜色,也可以不设置，自带也有颜色区分
  5.       let reg = '/'
  6.       sqlKeywords.forEach((keyword) => {
  7.         reg += `${keyword}|`
  8.       })
  9.       reg += '/'
  10.       this.color = monaco.languages.setMonarchTokensProvider('sql', {
  11.         ignoreCase: true,
  12.         tokenizer: {
  13.           root: [
  14.             [
  15.               reg,
  16.               { token: 'keyword' },
  17.             ], //蓝色
  18.             [
  19.               /[+]|[-]|[*]|[/]|[%]|[>]|[<]|[=]|[!]|[:]|[&&]|[||]/,
  20.               { token: 'string' },
  21.             ], //红色
  22.             [/'.*?'|".*?"/, { token: 'string.escape' }], //橙色
  23.             [/#--.*?\--#/, { token: 'comment' }], //绿色
  24.             [/null/, { token: 'regexp' }], //粉色
  25.             [/[{]|[}]/, { token: 'type' }], //青色
  26.             [/[\u4e00-\u9fa5]/, { token: 'predefined' }],//亮粉色
  27.             [/''/, { token: 'invalid' }],//红色
  28.             [/[\u4e00-\u9fa5]/, { token: 'number.binary' }],//浅绿
  29.             [/(?!.*[a-zA-Z])[0-9]/, { token: 'number.hex' }], //浅绿
  30.             [/[(]|[)]/, { token: 'number.octal' }], //浅绿
  31.             [/[\u4e00-\u9fa5]/, { token: 'number.float' }],//浅绿
  32.           ]
  33.         }
  34.       })
  35.  
  36. }

 格式化代码&标记错误

yarn add  sql-formatter@10.7.2 -D

  1. import { format } from 'sql-formatter'
  2.  
  3. initEditor() {
  4.  
  5.  // 改写插件自带格式化功能
  6.       const self = this
  7.       this.formatProvider = monaco.languages.registerDocumentFormattingEditProvider('sql', {
  8.         provideDocumentFormattingEdits(model) {
  9.           return [{
  10.             text: self.formatSql(1),
  11.             range: model.getFullModelRange()
  12.           }]
  13.         }
  14.       })
  15. }
  16.  
  17.  // 格式化代码
  18.     formatSql(needValue) {
  19.       this.clearMistake()
  20.       try {
  21.         this.setValue(format((this.editor).getValue()))
  22.       } catch (e) {
  23.         const {message} = e
  24.         const list = message.split(' ')
  25.         const line = list.indexOf('line')
  26.         const column = list.indexOf('column')
  27.         this.markMistake({
  28.           startLineNumber: Number(list[line + 1]),
  29.           endLineNumber: Number(list[line + 1]),
  30.           startColumn: Number(list[column + 1]),
  31.           endColumn: Number(list[column + 1])
  32.         }, 'Error', message)
  33.       }
  34.       if (needValue) {
  35.         return this.editor.getValue()
  36.       }
  37.     }
  38.  // 标记错误信息
  39.     markMistake(range, type, message) {
  40.       const {startLineNumber, endLineNumber, startColumn, endColumn} = range
  41.       monaco.editor.setModelMarkers(
  42.         this.editor.getModel(),
  43.         'eslint',
  44.         [{
  45.           startLineNumber,
  46.           endLineNumber,
  47.           startColumn,
  48.           endColumn,
  49.           severity: monaco.MarkerSeverity[type], // type可以是Error,Warning,Info
  50.           message
  51.         }]
  52.       )
  53.     }
  54.     // 清除错误信息
  55.     clearMistake() {
  56.       monaco.editor.setModelMarkers(
  57.         this.editor.getModel(),
  58.         'eslint',
  59.         []
  60.       )
  61.     }

 监听值变化

  1. initEditor() {
  2.     this.editor.onDidChangeModelContent(() => {
  3.         console.log('value', this.editor.getValue())
  4.     })
  5. }

销毁编辑器及其配置，防止自定义提示数据重复

  1. beforeDestroy () {
  2.   if (this.editor) {
  3.     this.clearMistake()
  4.     this.editor.dispose()
  5.     this.color.dispose()
  6.     this.suggestion.dispose()
  7.     this.formatProvider.dispose()
  8.   }
  9. }

--------------------------------------------------------------------------------------------------------------------------------

更新：附上SqlKeywords.js

  1. // SqlKeywords.js
  2.  
  3. export default [
  4.   'ACCESSIBLE',
  5.   'ACCOUNT',
  6.   'ACTION',
  7.   'ADD',
  8.   'AFTER',
  9.   'AGAINST',
  10.   'AGGREGATE',
  11.   'ALGORITHM',
  12.   'ALL',
  13.   'ALTER',
  14.   'ALWAYS',
  15.   'ANALYSE',
  16.   'ANALYZE',
  17.   'AND',
  18.   'ANY',
  19.   'AS',
  20.   'ASC',
  21.   'ASCII',
  22.   'ASENSITIVE',
  23.   'AT',
  24.   'AUTOEXTEND_SIZE',
  25.   'AUTO_INCREMENT',
  26.   'AVG',
  27.   'AVG_ROW_LENGTH',
  28.   'BACKUP',
  29.   'BEFORE',
  30.   'BEGIN',
  31.   'BETWEEN',
  32.   'BIGINT',
  33.   'BINARY',
  34.   'BINLOG',
  35.   'BIT',
  36.   'BLOB',
  37.   'BLOCK',
  38.   'BOOL',
  39.   'BOOLEAN',
  40.   'BOTH',
  41.   'BTREE',
  42.   'BY',
  43.   'BYTE',
  44.   'CACHE',
  45.   'CALL',
  46.   'CASCADE',
  47.   'CASCADED',
  48.   'CASE',
  49.   'CATALOG_NAME',
  50.   'CHAIN',
  51.   'CHANGE',
  52.   'CHANGED',
  53.   'CHANNEL',
  54.   'CHAR',
  55.   'CHARACTER',
  56.   'CHARSET',
  57.   'CHECK',
  58.   'CHECKSUM',
  59.   'CIPHER',
  60.   'CLASS_ORIGIN',
  61.   'CLIENT',
  62.   'CLOSE',
  63.   'COALESCE',
  64.   'CODE',
  65.   'COLLATE',
  66.   'COLLATION',
  67.   'COLUMN',
  68.   'COLUMNS',
  69.   'COLUMN_FORMAT',
  70.   'COLUMN_NAME',
  71.   'COMMENT',
  72.   'COMMIT',
  73.   'COMMITTED',
  74.   'COMPACT',
  75.   'COMPLETION',
  76.   'COMPRESSED',
  77.   'COMPRESSION',
  78.   'CONCURRENT',
  79.   'CONDITION',
  80.   'CONNECTION',
  81.   'CONSISTENT',
  82.   'CONSTRAINT',
  83.   'CONSTRAINT_CATALOG',
  84.   'CONSTRAINT_NAME',
  85.   'CONSTRAINT_SCHEMA',
  86.   'CONTAINS',
  87.   'CONTEXT',
  88.   'CONTINUE',
  89.   'CONVERT',
  90.   'CPU',
  91.   'CREATE',
  92.   'CROSS',
  93.   'CUBE',
  94.   'CURRENT',
  95.   'CURRENT_DATE',
  96.   'CURRENT_TIME',
  97.   'CURRENT_TIMESTAMP',
  98.   'CURRENT_USER',
  99.   'CURSOR',
  100.   'CURSOR_NAME',
  101.   'DATA',
  102.   'DATABASE',
  103.   'DATABASES',
  104.   'DATAFILE',
  105.   'DATE',
  106.   'DATETIME',
  107.   'DAY',
  108.   'DAY_HOUR',
  109.   'DAY_MICROSECOND',
  110.   'DAY_MINUTE',
  111.   'DAY_SECOND',
  112.   'DEALLOCATE',
  113.   'DEC',
  114.   'DECIMAL',
  115.   'DECLARE',
  116.   'DEFAULT',
  117.   'DEFAULT_AUTH',
  118.   'DEFINER',
  119.   'DELAYED',
  120.   'DELAY_KEY_WRITE',
  121.   'DELETE',
  122.   'DESC',
  123.   'DESCRIBE',
  124.   'DES_KEY_FILE',
  125.   'DETERMINISTIC',
  126.   'DIAGNOSTICS',
  127.   'DIRECTORY',
  128.   'DISABLE',
  129.   'DISCARD',
  130.   'DISK',
  131.   'DISTINCT',
  132.   'DISTINCTROW',
  133.   'DIV',
  134.   'DO',
  135.   'DOUBLE',
  136.   'DROP',
  137.   'DUAL',
  138.   'DUMPFILE',
  139.   'DUPLICATE',
  140.   'DYNAMIC',
  141.   'EACH',
  142.   'ELSE',
  143.   'ELSEIF',
  144.   'ENABLE',
  145.   'ENCLOSED',
  146.   'ENCRYPTION',
  147.   'END',
  148.   'ENDS',
  149.   'ENGINE',
  150.   'ENGINES',
  151.   'ENUM',
  152.   'ERROR',
  153.   'ERRORS',
  154.   'ESCAPE',
  155.   'ESCAPED',
  156.   'EVENT',
  157.   'EVENTS',
  158.   'EVERY',
  159.   'EXCHANGE',
  160.   'EXECUTE',
  161.   'EXISTS',
  162.   'EXIT',
  163.   'EXPANSION',
  164.   'EXPIRE',
  165.   'EXPLAIN',
  166.   'EXPORT',
  167.   'EXTENDED',
  168.   'EXTENT_SIZE',
  169.   'FALSE',
  170.   'FAST',
  171.   'FAULTS',
  172.   'FETCH',
  173.   'FIELDS',
  174.   'FILE',
  175.   'FILE_BLOCK_SIZE',
  176.   'FILTER',
  177.   'FIRST',
  178.   'FIXED',
  179.   'FLOAT',
  180.   'FLOAT4',
  181.   'FLOAT8',
  182.   'FLUSH',
  183.   'FOLLOWS',
  184.   'FOR',
  185.   'FORCE',
  186.   'FOREIGN',
  187.   'FORMAT',
  188.   'FOUND',
  189.   'FROM',
  190.   'FULL',
  191.   'FULLTEXT',
  192.   'FUNCTION',
  193.   'GENERAL',
  194.   'GENERATED',
  195.   'GEOMETRY',
  196.   'GEOMETRYCOLLECTION',
  197.   'GET',
  198.   'GET_FORMAT',
  199.   'GLOBAL',
  200.   'GRANT',
  201.   'GRANTS',
  202.   'GROUP',
  203.   'GROUP_REPLICATION',
  204.   'HANDLER',
  205.   'HASH',
  206.   'HAVING',
  207.   'HELP',
  208.   'HIGH_PRIORITY',
  209.   'HOST',
  210.   'HOSTS',
  211.   'HOUR',
  212.   'HOUR_MICROSECOND',
  213.   'HOUR_MINUTE',
  214.   'HOUR_SECOND',
  215.   'IDENTIFIED',
  216.   'IF',
  217.   'IGNORE',
  218.   'IGNORE_SERVER_IDS',
  219.   'IMPORT',
  220.   'IN',
  221.   'INDEX',
  222.   'INDEXES',
  223.   'INFILE',
  224.   'INITIAL_SIZE',
  225.   'INNER',
  226.   'INOUT',
  227.   'INSENSITIVE',
  228.   'INSERT',
  229.   'INSERT_METHOD',
  230.   'INSTALL',
  231.   'INSTANCE',
  232.   'INT',
  233.   'INT1',
  234.   'INT2',
  235.   'INT3',
  236.   'INT4',
  237.   'INT8',
  238.   'INTEGER',
  239.   'INTERVAL',
  240.   'INTO',
  241.   'INVOKER',
  242.   'IO',
  243.   'IO_AFTER_GTIDS',
  244.   'IO_BEFORE_GTIDS',
  245.   'IO_THREAD',
  246.   'IPC',
  247.   'IS',
  248.   'ISOLATION',
  249.   'ISSUER',
  250.   'ITERATE',
  251.   'JOIN',
  252.   'JSON',
  253.   'KEY',
  254.   'KEYS',
  255.   'KEY_BLOCK_SIZE',
  256.   'KILL',
  257.   'LANGUAGE',
  258.   'LAST',
  259.   'LEADING',
  260.   'LEAVE',
  261.   'LEAVES',
  262.   'LEFT',
  263.   'LESS',
  264.   'LEVEL',
  265.   'LIKE',
  266.   'LIMIT',
  267.   'LINEAR',
  268.   'LINES',
  269.   'LINESTRING',
  270.   'LIST',
  271.   'LOAD',
  272.   'LOCAL',
  273.   'LOCALTIME',
  274.   'LOCALTIMESTAMP',
  275.   'LOCK',
  276.   'LOCKS',
  277.   'LOGFILE',
  278.   'LOGS',
  279.   'LONG',
  280.   'LONGBLOB',
  281.   'LONGTEXT',
  282.   'LOOP',
  283.   'LOW_PRIORITY',
  284.   'MASTER',
  285.   'MASTER_AUTO_POSITION',
  286.   'MASTER_BIND',
  287.   'MASTER_CONNECT_RETRY',
  288.   'MASTER_DELAY',
  289.   'MASTER_HEARTBEAT_PERIOD',
  290.   'MASTER_HOST',
  291.   'MASTER_LOG_FILE',
  292.   'MASTER_LOG_POS',
  293.   'MASTER_PASSWORD',
  294.   'MASTER_PORT',
  295.   'MASTER_RETRY_COUNT',
  296.   'MASTER_SERVER_ID',
  297.   'MASTER_SSL',
  298.   'MASTER_SSL_CA',
  299.   'MASTER_SSL_CAPATH',
  300.   'MASTER_SSL_CERT',
  301.   'MASTER_SSL_CIPHER',
  302.   'MASTER_SSL_CRL',
  303.   'MASTER_SSL_CRLPATH',
  304.   'MASTER_SSL_KEY',
  305.   'MASTER_SSL_VERIFY_SERVER_CERT',
  306.   'MASTER_TLS_VERSION',
  307.   'MASTER_USER',
  308.   'MATCH',
  309.   'MAXVALUE',
  310.   'MAX_CONNECTIONS_PER_HOUR',
  311.   'MAX_QUERIES_PER_HOUR',
  312.   'MAX_ROWS',
  313.   'MAX_SIZE',
  314.   'MAX_STATEMENT_TIME',
  315.   'MAX_UPDATES_PER_HOUR',
  316.   'MAX_USER_CONNECTIONS',
  317.   'MEDIUM',
  318.   'MEDIUMBLOB',
  319.   'MEDIUMINT',
  320.   'MEDIUMTEXT',
  321.   'MEMORY',
  322.   'MERGE',
  323.   'MESSAGE_TEXT',
  324.   'MICROSECOND',
  325.   'MIDDLEINT',
  326.   'MIGRATE',
  327.   'MINUTE',
  328.   'MINUTE_MICROSECOND',
  329.   'MINUTE_SECOND',
  330.   'MIN_ROWS',
  331.   'MOD',
  332.   'MODE',
  333.   'MODIFIES',
  334.   'MODIFY',
  335.   'MONTH',
  336.   'MULTILINESTRING',
  337.   'MULTIPOINT',
  338.   'MULTIPOLYGON',
  339.   'MUTEX',
  340.   'MYSQL_ERRNO',
  341.   'NAME',
  342.   'NAMES',
  343.   'NATIONAL',
  344.   'NATURAL',
  345.   'NCHAR',
  346.   'NDB',
  347.   'NDBCLUSTER',
  348.   'NEVER',
  349.   'NEW',
  350.   'NEXT',
  351.   'NO',
  352.   'NODEGROUP',
  353.   'NONBLOCKING',
  354.   'NONE',
  355.   'NOT',
  356.   'NO_WAIT',
  357.   'NO_WRITE_TO_BINLOG',
  358.   'NULL',
  359.   'NUMBER',
  360.   'NUMERIC',
  361.   'NVARCHAR',
  362.   'OFFSET',
  363.   'OLD_PASSWORD',
  364.   'ON',
  365.   'ONE',
  366.   'ONLY',
  367.   'OPEN',
  368.   'OPTIMIZE',
  369.   'OPTIMIZER_COSTS',
  370.   'OPTION',
  371.   'OPTIONALLY',
  372.   'OPTIONS',
  373.   'OR',
  374.   'ORDER',
  375.   'OUT',
  376.   'OUTER',
  377.   'OUTFILE',
  378.   'OWNER',
  379.   'PACK_KEYS',
  380.   'PAGE',
  381.   'PARSER',
  382.   'PARSE_GCOL_EXPR',
  383.   'PARTIAL',
  384.   'PARTITION',
  385.   'PARTITIONING',
  386.   'PARTITIONS',
  387.   'PASSWORD',
  388.   'PHASE',
  389.   'PLUGIN',
  390.   'PLUGINS',
  391.   'PLUGIN_DIR',
  392.   'POINT',
  393.   'POLYGON',
  394.   'PORT',
  395.   'PRECEDES',
  396.   'PRECISION',
  397.   'PREPARE',
  398.   'PRESERVE',
  399.   'PREV',
  400.   'PRIMARY',
  401.   'PRIVILEGES',
  402.   'PROCEDURE',
  403.   'PROCESSLIST',
  404.   'PROFILE',
  405.   'PROFILES',
  406.   'PROXY',
  407.   'PURGE',
  408.   'QUARTER',
  409.   'QUERY',
  410.   'QUICK',
  411.   'RANGE',
  412.   'READ',
  413.   'READS',
  414.   'READ_ONLY',
  415.   'READ_WRITE',
  416.   'REAL',
  417.   'REBUILD',
  418.   'RECOVER',
  419.   'REDOFILE',
  420.   'REDO_BUFFER_SIZE',
  421.   'REDUNDANT',
  422.   'REFERENCES',
  423.   'REGEXP',
  424.   'RELAY',
  425.   'RELAYLOG',
  426.   'RELAY_LOG_FILE',
  427.   'RELAY_LOG_POS',
  428.   'RELAY_THREAD',
  429.   'RELEASE',
  430.   'RELOAD',
  431.   'REMOVE',
  432.   'RENAME',
  433.   'REORGANIZE',
  434.   'REPAIR',
  435.   'REPEAT',
  436.   'REPEATABLE',
  437.   'REPLACE',
  438.   'REPLICATE_DO_DB',
  439.   'REPLICATE_DO_TABLE',
  440.   'REPLICATE_IGNORE_DB',
  441.   'REPLICATE_IGNORE_TABLE',
  442.   'REPLICATE_REWRITE_DB',
  443.   'REPLICATE_WILD_DO_TABLE',
  444.   'REPLICATE_WILD_IGNORE_TABLE',
  445.   'REPLICATION',
  446.   'REQUIRE',
  447.   'RESET',
  448.   'RESIGNAL',
  449.   'RESTORE',
  450.   'RESTRICT',
  451.   'RESUME',
  452.   'RETURN',
  453.   'RETURNED_SQLSTATE',
  454.   'RETURNS',
  455.   'REVERSE',
  456.   'REVOKE',
  457.   'RIGHT',
  458.   'RLIKE',
  459.   'ROLLBACK',
  460.   'ROLLUP',
  461.   'ROTATE',
  462.   'ROUTINE',
  463.   'ROW',
  464.   'ROWS',
  465.   'ROW_COUNT',
  466.   'ROW_FORMAT',
  467.   'RTREE',
  468.   'SAVEPOINT',
  469.   'SCHEDULE',
  470.   'SCHEMA',
  471.   'SCHEMAS',
  472.   'SCHEMA_NAME',
  473.   'SECOND',
  474.   'SECOND_MICROSECOND',
  475.   'SECURITY',
  476.   'SELECT',
  477.   'SENSITIVE',
  478.   'SEPARATOR',
  479.   'SERIAL',
  480.   'SERIALIZABLE',
  481.   'SERVER',
  482.   'SESSION',
  483.   'SET',
  484.   'SHARE',
  485.   'SHOW',
  486.   'SHUTDOWN',
  487.   'SIGNAL',
  488.   'SIGNED',
  489.   'SIMPLE',
  490.   'SLAVE',
  491.   'SLOW',
  492.   'SMALLINT',
  493.   'SNAPSHOT',
  494.   'SOCKET',
  495.   'SOME',
  496.   'SONAME',
  497.   'SOUNDS',
  498.   'SOURCE',
  499.   'SPATIAL',
  500.   'SPECIFIC',
  501.   'SQL',
  502.   'SQLEXCEPTION',
  503.   'SQLSTATE',
  504.   'SQLWARNING',
  505.   'SQL_AFTER_GTIDS',
  506.   'SQL_AFTER_MTS_GAPS',
  507.   'SQL_BEFORE_GTIDS',
  508.   'SQL_BIG_RESULT',
  509.   'SQL_BUFFER_RESULT',
  510.   'SQL_CACHE',
  511.   'SQL_CALC_FOUND_ROWS',
  512.   'SQL_NO_CACHE',
  513.   'SQL_SMALL_RESULT',
  514.   'SQL_THREAD',
  515.   'SQL_TSI_DAY',
  516.   'SQL_TSI_HOUR',
  517.   'SQL_TSI_MINUTE',
  518.   'SQL_TSI_MONTH',
  519.   'SQL_TSI_QUARTER',
  520.   'SQL_TSI_SECOND',
  521.   'SQL_TSI_WEEK',
  522.   'SQL_TSI_YEAR',
  523.   'SSL',
  524.   'STACKED',
  525.   'START',
  526.   'STARTING',
  527.   'STARTS',
  528.   'STATS_AUTO_RECALC',
  529.   'STATS_PERSISTENT',
  530.   'STATS_SAMPLE_PAGES',
  531.   'STATUS',
  532.   'STOP',
  533.   'STORAGE',
  534.   'STORED',
  535.   'STRAIGHT_JOIN',
  536.   'STRING',
  537.   'SUBCLASS_ORIGIN',
  538.   'SUBJECT',
  539.   'SUBPARTITION',
  540.   'SUBPARTITIONS',
  541.   'SUPER',
  542.   'SUSPEND',
  543.   'SWAPS',
  544.   'SWITCHES',
  545.   'TABLE',
  546.   'TABLES',
  547.   'TABLESPACE',
  548.   'TABLE_CHECKSUM',
  549.   'TABLE_NAME',
  550.   'TEMPORARY',
  551.   'TEMPTABLE',
  552.   'TERMINATED',
  553.   'TEXT',
  554.   'THAN',
  555.   'THEN',
  556.   'TIME',
  557.   'TIMESTAMP',
  558.   'TIMESTAMPADD',
  559.   'TIMESTAMPDIFF',
  560.   'TINYBLOB',
  561.   'TINYINT',
  562.   'TINYTEXT',
  563.   'TO',
  564.   'TRAILING',
  565.   'TRANSACTION',
  566.   'TRIGGER',
  567.   'TRIGGERS',
  568.   'TRUE',
  569.   'TRUNCATE',
  570.   'TYPE',
  571.   'TYPES',
  572.   'UNCOMMITTED',
  573.   'UNDEFINED',
  574.   'UNDO',
  575.   'UNDOFILE',
  576.   'UNDO_BUFFER_SIZE',
  577.   'UNICODE',
  578.   'UNINSTALL',
  579.   'UNION',
  580.   'UNIQUE',
  581.   'UNKNOWN',
  582.   'UNLOCK',
  583.   'UNSIGNED',
  584.   'UNTIL',
  585.   'UPDATE',
  586.   'UPGRADE',
  587.   'USAGE',
  588.   'USE',
  589.   'USER',
  590.   'USER_RESOURCES',
  591.   'USE_FRM',
  592.   'USING',
  593.   'UTC_DATE',
  594.   'UTC_TIME',
  595.   'UTC_TIMESTAMP',
  596.   'VALIDATION',
  597.   'VALUE',
  598.   'VALUES',
  599.   'VARBINARY',
  600.   'VARCHAR',
  601.   'VARCHARACTER',
  602.   'VARIABLES',
  603.   'VARYING',
  604.   'VIEW',
  605.   'VIRTUAL',
  606.   'WAIT',
  607.   'WARNINGS',
  608.   'WEEK',
  609.   'WEIGHT_STRING',
  610.   'WHEN',
  611.   'WHERE',
  612.   'WHILE',
  613.   'WITH',
  614.   'WITHOUT',
  615.   'WORK',
  616.   'WRAPPER',
  617.   'WRITE',
  618.   'X509',
  619.   'XA',
  620.   'XID',
  621.   'XML',
  622.   'XOR',
  623.   'YEAR',
  624.   'YEAR_MONTH',
  625.   'ZEROFILL'
  626. ]

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/710261
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号