go整理tidb/mysql所有关键字,保留字

// tidb 暂时不支持'SELECT * FROM mysql.help_keyword;', 支持后可以替换一下
var keyWords = map[string]struct{}{
    "ACTION":{},"ADD":{},"ADDDATE":{},"ADMIN":{},"AFTER":{},"ALL":{},"ALTER":{},"ALWAYS":{},"ANALYZE":{},
    "AND":{},"ANY":{},"AS":{},"ASC":{},"ASCII":{},"AUTO_INCREMENT":{},"AVG":{},"AVG_ROW_LENGTH":{},

    "BEGIN":{},"BETWEEN":{},"BIGINT":{},"BINARY":{},"BINLOG":{},"BIT":{},"BIT_XOR":{},"BLOB":{},"BOOL":{},
    "BOOLEAN":{},"BOTH":{},"BTREE":{},"BY":{},"BYTE":{},

    "CASCADE":{},"CASE":{},"CAST":{},"CHANGE":{},"CHAR":{},"CHARACTER":{},"CHARSET":{},"CHECK":{},"CHECKSUM":{},
    "COALESCE":{},"COLLATE":{},"COLLATION":{},"COLUMN":{},"COLUMNS":{},"COMMENT":{},"COMMIT":{},"COMMITTED":{},"COMPACT":{},
    "COMPRESSED":{},"COMPRESSION":{},"CONNECTION":{},"CONSISTENT":{},"CONSTRAINT":{},"CONVERT":{},"COUNT":{},"CREATE":{},"CROSS":{},
    "CUME_DIST":{},"CURRENT_DATE":{},"CURRENT_TIME":{},"CURRENT_TIMESTAMP":{},"CURRENT_USER":{},"CURTIME":{},

    "DATA":{},"DATABASE":{},"DATABASES":{},"DATE":{},"DATE_ADD":{},"DATE_SUB":{},"DATETIME":{},"DAY":{},"DAY_HOUR":{},
    "DAY_MICROSECOND":{},"DAY_MINUTE":{},"DAY_SECOND":{},"DDL":{},"DEALLOCATE":{},"DEC":{},"DECIMAL":{},"DEFAULT":{},"DELAY_KEY_WRITE":{},
    "DELAYED":{},"DELETE":{},"DENSE_RANK":{},"DESC":{},"DESCRIBE":{},"DISABLE":{},"DISTINCT":{},"DISTINCTROW":{},"DIV":{},
    "DO":{},"DOUBLE":{},"DROP":{},"DUAL":{},"DUPLICATE":{},"DYNAMIC":{},

    "ELSE":{},"ENABLE":{},"ENCLOSED":{},"END":{},"ENGINE":{},"ENGINES":{},"ENUM":{},"ESCAPE":{},"ESCAPED":{},
    "EVENTS":{},"EXCLUSIVE":{},"EXECUTE":{},"EXISTS":{},"EXPLAIN":{},"EXTRACT":{},

    "FALSE":{},"FIELDS":{},"FIRST":{},"FIRST_VALUE":{},"FIXED":{},"FLOAT":{},"FLUSH":{},"FOR":{},"FORCE":{},
    "FOREIGN":{},"FORMAT":{},"FROM":{},"FULL":{},"FULLTEXT":{},"FUNCTION":{},

    "GENERATED":{},"GET_FORMAT":{},"GLOBAL":{},"GRANT":{},"GRANTS":{},"GROUP":{},"GROUP_CONCAT":{},"GROUPS":{},


    "HASH":{},"HAVING":{},"HIGH_PRIORITY":{},"HOUR":{},"HOUR_MICROSECOND":{},"HOUR_MINUTE":{},"HOUR_SECOND":{},

    "IDENTIFIED":{},"IF":{},"IGNORE":{},"IN":{},"INDEX":{},"INDEXES":{},"INFILE":{},"INNER":{},"INSERT":{},
    "INT":{},"INTEGER":{},"INTERVAL":{},"INTO":{},"IS":{},"ISOLATION":{},

    "JOBS":{},"JOIN":{},"JSON":{},

    "KEY":{},"KEY_BLOCK_SIZE":{},"KEYS":{},"KILL":{},

    "LAG":{},"LAST_VALUE":{},"LEAD":{},"LEADING":{},"LEFT":{},"LESS":{},"LEVEL":{},"LIKE":{},"LIMIT":{},
    "LINES":{},"LOAD":{},"LOCAL":{},"LOCALTIME":{},"LOCALTIMESTAMP":{},"LOCK":{},"LONGBLOB":{},"LONGTEXT":{},"LOW_PRIORITY":{},

    "MAX":{},"MAX_ROWS":{},"MAXVALUE":{},"MEDIUMBLOB":{},"MEDIUMINT":{},"MEDIUMTEXT":{},"MICROSECOND":{},"MIN":{},"MIN_ROWS":{},
    "MINUTE":{},"MINUTE_MICROSECOND":{},"MINUTE_SECOND":{},"MOD":{},"MODE":{},"MODIRY":{},"MONTH":{},

    "NAMES":{},"NATIONAL":{},"NATURAL":{},"NO":{},"NO_WRITE_TO_BINLOG":{},"NONE":{},"NOT":{},"NOW":{},"NTH_VALUE":{},
    "NTILE":{},"NULL":{},"NUMERIC":{},"NVARCHAR":{},


    "OFFSET":{},"ON":{},"ONLY":{},"OPTION":{},"OR":{},"ORDER":{},"OUTER":{},"OVER":{},

    "PARTITION":{},"PARTITIONS":{},"PASSWORD":{},"PERCENT_RANK":{},"PLUGINS":{},"POSITION":{},"PRECISION":{},"PREPARE":{},"PRIMARY":{},
    "PRIVILEGES":{},"PROCEDURE":{},"PROCESS":{},"PROCESSLIST":{},

    "QUARTER":{},"QUERY":{},"QUICK":{},

    "RANGE":{},"RANK":{},"READ":{},"REAL":{},"REDUNDANT":{},"REFERENCES":{},"REGEXP":{},"RENAME":{},"REPEAT":{},
    "REPEATABLE":{},"REPLACE":{},"RESTRICT":{},"REVERSE":{},"REVOKE":{},"RIGHT":{},"RLIKE":{},"ROLLBACK":{},"ROW":{},
    "ROW_COUNT":{},"ROW_FORMAT":{},"ROW_NUMBER":{},"ROWS":{},

    "SCHEMA":{},"SCHEMAS":{},"SECOND":{},"SECOND_MICROSECOND":{},"SELECT":{},"SERIALIZABLE":{},"SESSION":{},"SET":{},"SHARE":{},
    "SHARED":{},"SHOW":{},"SIGNED":{},"SMALLINT":{},"SNAPSHOT":{},"SOME":{},"SQL_CACHE":{},"SQL_CALC_FOUND_ROWS":{},"SQL_NO_CACHE":{},
    "START":{},"STARTING":{},"STATS":{},"STATS_BUCKETS":{},"STATS_HISTOGRAMS":{},"STATS_META":{},"STATS_PERSISTENT":{},"STATUS":{},"STORED":{},
    "SUBDATE":{},"SUBSTR":{},"SUBSTRING":{},"SUM":{},"SUPER":{},

    "TABLE":{},"TABLES":{},"TERMINATED":{},"TEXT":{},"THAN":{},"THEN":{},"TIDB":{},"TIDB_INLJ":{},"TIDB_SMJ":{},
    "TIME":{},"TIMESTAMP":{},"TIMESTAMPADD":{},"TIMESTAMPDIFF":{},"TINYBLOB":{},"TINYINT":{},"TINYTEXT":{},"TO":{},"TRAILING":{},
    "TRANSACTION":{},"TRIGGER":{},"TRIGGERS":{},"TRIM":{},"TRUE":{},"TRUNCATE":{},

    "UNCOMMITTED":{},"UNION":{},"UNIQUE":{},"UNKNOWN":{},"UNLOCK":{},"UNSIGNED":{},"UPDATE":{},"USE":{},"USER":{},
    "USING":{},"UTC_DATE":{},"UTC_TIME":{},"UTC_TIMESTAMP":{},

    "VALUE":{},"VALUES":{},"VARBINARY":{},"VARCHAR":{},"VARIABLES":{},"VIEW":{},"VIRTUAL":{},

    "WARNINGS":{},"WEEK":{},"WHEN":{},"WHERE":{},"WINDOW":{},"WITH":{},"WRITE":{},

    "XOR":{},"YEAR":{},"YEAR_MONTH":{},"ZEROFILL":{},
}

func isKeyWord(name string) bool {
    name = strings.ToUpper(name)
    if _, ok := keyWords[name];ok{
        return true
    }
    return false
}

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
  • 序言:七十年代末,一起剥皮案震惊了整个滨河市,随后出现的几起案子,更是在滨河造成了极大的恐慌,老刑警刘岩,带你破解...
    沈念sama阅读 203,937评论 6 478
  • 序言:滨河连续发生了三起死亡事件,死亡现场离奇诡异,居然都是意外死亡,警方通过查阅死者的电脑和手机,发现死者居然都...
    沈念sama阅读 85,503评论 2 381
  • 文/潘晓璐 我一进店门,熙熙楼的掌柜王于贵愁眉苦脸地迎上来,“玉大人,你说我怎么就摊上这事。” “怎么了?”我有些...
    开封第一讲书人阅读 150,712评论 0 337
  • 文/不坏的土叔 我叫张陵,是天一观的道长。 经常有香客问我,道长,这世上最难降的妖魔是什么? 我笑而不...
    开封第一讲书人阅读 54,668评论 1 276
  • 正文 为了忘掉前任,我火速办了婚礼,结果婚礼上,老公的妹妹穿的比我还像新娘。我一直安慰自己,他们只是感情好,可当我...
    茶点故事阅读 63,677评论 5 366
  • 文/花漫 我一把揭开白布。 她就那样静静地躺着,像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上,一...
    开封第一讲书人阅读 48,601评论 1 281
  • 那天,我揣着相机与录音,去河边找鬼。 笑死,一个胖子当着我的面吹牛,可吹牛的内容都是我干的。 我是一名探鬼主播,决...
    沈念sama阅读 37,975评论 3 396
  • 文/苍兰香墨 我猛地睁开眼,长吁一口气:“原来是场噩梦啊……” “哼!你这毒妇竟也来了?” 一声冷哼从身侧响起,我...
    开封第一讲书人阅读 36,637评论 0 258
  • 序言:老挝万荣一对情侣失踪,失踪者是张志新(化名)和其女友刘颖,没想到半个月后,有当地人在树林里发现了一具尸体,经...
    沈念sama阅读 40,881评论 1 298
  • 正文 独居荒郊野岭守林人离奇死亡,尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 35,621评论 2 321
  • 正文 我和宋清朗相恋三年,在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 37,710评论 1 329
  • 序言:一个原本活蹦乱跳的男人离奇死亡,死状恐怖,灵堂内的尸体忽然破棺而出,到底是诈尸还是另有隐情,我是刑警宁泽,带...
    沈念sama阅读 33,387评论 4 319
  • 正文 年R本政府宣布,位于F岛的核电站,受9级特大地震影响,放射性物质发生泄漏。R本人自食恶果不足惜,却给世界环境...
    茶点故事阅读 38,971评论 3 307
  • 文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹,春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 29,947评论 0 19
  • 文/苍兰香墨 我抬头看了看天上的太阳。三九已至,却和暖如春,着一层夹袄步出监牢的瞬间,已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 31,189评论 1 260
  • 我被黑心中介骗来泰国打工, 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留,地道东北人。 一个月前我还...
    沈念sama阅读 44,805评论 2 349
  • 正文 我出身青楼,却偏偏与公主长得像,于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子,可洞房花烛夜当晚...
    茶点故事阅读 42,449评论 2 342