MYSQL8.0所有关键字数组形式

已于 2023-04-19 14:28:48 修改
阅读量235 收藏
点赞数
文章标签： mysql
于 2023-04-19 14:27:21 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/leoisaking/article/details/130243216
版权

MYSQL8.0所有关键字数组形式

参考于mysql官网：https://dev.mysql.com/doc/refman/8.0/en/keywords.html

["ACCESSIBLE", "ACCOUNT", "ACTION", "ACTIVE", "ADD", "ADMIN", "AFTER", "AGAINST",
            "AGGREGATE", "ALGORITHM", "ALL", "ALTER", "ANALYSE", "ANALYZE", "AND", "ANY",
            "ARRAY", "AS", "ASC", "ASCII", "ASENSITIVE", "AT", "ATTRIBUTE", "AUTHENTICATION",
            "AUTOEXTEND_SIZE", "AUTO_INCREMENT", "AVG", "AVG_ROW_LENGTH",
            "BACKUP", "BEFORE", "BEGIN", "BETWEEN", "BIGINT", "BINARY", "BINLOG", "BIT",
            "BLOB", "BLOCK", "BOOL", "BOOLEAN", "BOTH", "BTREE", "BY", "BUCKETS", "BULK", "BY", "BYTE",
            "CACHE", "CALL", "CASCADE", "CASCADED", "CASE", "CATALOG_NAME", "CHAIN",
            "CHALLENGE_RESPONSE", "CHANGE", "CHANGED", "CHANNEL", "CHAR", "CHARACTER",
            "CHARSET", "CHECK", "CHECKSUM", "CIPHER", "CLASS_ORIGIN", "CLIENT", "CLONE",
            "CLOSE", "COALESCE", "CODE", "COLLATE", "COLLAFTION", "COLUMN", "COLUMNS",
            "COLUMN_FORMAT", "COLUMN_NAME", "COMMENT", "COMMIT", "COMMITTED", "COMPACT",
            "COMPLETION", "COMPONENT", "COMPRESSED", "COMPRESSION", "CONCURRENT", "CONDITION",
            "CONNECTION", "CONSISTENT", "CONSTRAINT", "CONSTRAINT_CATALOG", "CONSTRAINT_NAME",
            "CONSTRAINT_SCHEMA", "CONTAINS", "CONTEXT", "CONTINUE", "CONVERT", "CPU", "CREATE",
            "CROSS", "CUBE", "CUME_DIST", "CURRENT", "CURRENT_DATE", "CURRENT_TIME",
            "CURRENT_TIMESTAMP", "CURRENT_USER", "CURSOR", "CURSOR_NAME",
            "DATA", "DATABASE", "DATABASES", "DATAFILE", "DATE", "DATETIME", "DAY",
            "DAY_HOUR", "DAY_MICROSECOND", "DAY_MINUTE", "DAY_SECOND", "DEALLOCATE", "DEC",
            "DECIMAL", "DECLARE", "DEFAULT", "DEFAULT_AUTH", "DEFINER", "DEFINITION", "DELAYED",
            "DELAY_KEY_WRITE", "DELETE", "DENSE_RANK", "DESC", "DESCRIBE", "DESCRIPTION",
            "DES_KEY_FILE", "DETERMINISTIC", "DIAGNOSTICS", "DIRECTORY", "DISABLE", "DISCARD",
            "DISK", "DISTINCT", "DISTINCTROW", "DIV", "DO", "DOUBLE", "DROP", "DUAL",
            "DUMPFILE", "DUPLICATE", "DYNAMIC",
            "EACH", "ELSE", "ELSEIF", "EMPTY", "ENABLE", "ENCLOSED", "ENCRYPTION",
            "END", "ENDS", "ENFORCED", "ENGINE", "ENGINES", "ENGINE_ATTRIBUTE", "ENUM",
            "ERROR", "ERRORS", "ESCAPE", "ESCAPED", "EVENT", "EVENTS", "EVERY", "EXCEPT",
            "EXCHANGE", "EXCLUDE", "EXECUTE", "EXISTS", "EXIT", "EXPANSION", "EXPIRE",
            "EXPLAIN", "EXPORT", "EXTENDED", "EXTENT_SIZE",
            "FACTOR", "FAILED_LOGIN_ATTEMPTS", "FALSE", "FAST", "FAULTS", "FETCH",
            "FIELDS", "FILE", "FILE_BLOCK_SIZE", "FILTER", "FINISH", "FIRST", "FIRST_VALUE",
            "FIXED", "FLOAT", "FLOAT4", "FLOAT8", "FLUSH", "FOLLOWING", "FOLLOWS", "FOR",
            "FORCE", "FOREIGN", "FORMAT", "FOUND", "FROM", "FULL", "FULLTEXT", "FUNCTION",
            "GENERAL", "GENERATE", "GENERATED", "GEOMCOLLECTION", "GEOMETRY",
            "GEOMETRYCOLLECTION", "GET", "GET_FORMAT", "GET_MASTER_PUBLIC_KEY",
            "GET_SOURCE_PUBLIC_KEY", "GLOBAL", "GRANT", "GRANTS", "GROUP", "GROUPING",
            "GROUPS", "GROUP_REPLICATION", "GTID_ONLY",
            "HANDLER", "HASH", "HAVING", "HELP", "HIGH_PRIORITY", "HISTOGRAM", "HISTORY",
            "HOST", "HOSTS", "HOUR", "HOUR_MICROSECOND", "HOUR_MINUTE", "HOUR_SECOND",
            "IDENTIFIED", "IF", "IGNORE", "IGNORE_SERVER_IDS", "IMPORT", "IN",
            "INDEX", "INDEXES", "INFILE", "INITIAL", "INITIAL_SIZE", "INITIATE",
            "INNER", "INOUT", "INSENSITIVE", "INSERT", "INSERT_METHOD", "INSTALL",
            "INSTANCE", "INT", "INT1", "INT2", "INT3", "INT4", "INT8", "INTEGER",
            "INTERSECT", "INTERVAL", "INTO", "INVISIBLE", "INVOKER", "IO", "IO_AFTER_GTIDS",
            "IO_BEFORE_GTIDS", "IO_THREAD", "IPC", "IS", "ISOLATION", "ISSUER", "ITERATE",
            "JOIN", "JSON", "JSON_TABLE", "JSON_VALUE",
            "KEY", "KEYRING", "KEYS", "KEY_BLOCK_SIZE", "KILL",
            "LAG", "LANGUAGE", "LAST", "LAST_VALUE", "LATERAL", "LEAD", "LEADING", "LEAVE",
            "LEAVES", "LEFT", "LESS", "LEVEL", "LIKE", "LIMIT", "LINEAR", "LINES",
            "LINESTRING", "LIST", "LOAD", "LOCAL", "LOCALTIME", "LOCALTIMESTAMP", "LOCK",
            "LOCKED", "LOCKS", "LOGFILE", "LOGS", "LONG", "LONGBLOB",
            "LONGTEXT", "LOOP", "LOW_PRIORITY",
            "MASTER", "MASTER_AUTO_POSITION", "MASTER_BIND", "MASTER_COMPRESSION_ALGORITHMS",
            "MASTER_CONNECT_RETRY", "MASTER_DELAY", "MASTER_HEARTBEAT_PERIOD", "MASTER_HOST",
            "MASTER_LOG_FILE", "MASTER_LOG_POS", "MASTER_PASSWORD", "MASTER_PORT",
            "MASTER_PUBLIC_KEY_PATH", "MASTER_RETRY_COUNT", "MASTER_SERVER_ID", "MASTER_SSL",
            "MASTER_SSL_CA", "MASTER_SSL_CAPATH", "MASTER_SSL_CERT", "MASTER_SSL_CIPHER",
            "MASTER_SSL_CRL", "MASTER_SSL_CRLPATH", "MASTER_SSL_KEY", "MASTER_SSL_VERIFY_SERVER_CERT",
            "MASTER_TLS_CIPHERSUITES", "MASTER_TLS_VERSION", "MASTER_USER",
            "MASTER_ZSTD_COMPRESSION_LEVEL", "MATCH", "MAXVALUE", "MAX_CONNECTIONS_PER_HOUR",
            "MAX_QUERIES_PER_HOUR", "MAX_ROWS", "MAX_SIZE", "MAX_UPDATES_PER_HOUR",
            "MAX_USER_CONNECTIONS", "MEDIUM", "MEDIUMBLOB", "MEDIUMINT", "MEDIUMTEXT", "MEMBER",
            "MEMORY", "MERGE", "MESSAGE_TEXT", "MICROSECOND", "MIDDLEINT", "MIGRATE", "MINUTE",
            "MINUTE_MICROSECOND", "MINUTE_SECOND", "MIN_ROWS", "MOD", "MODE", "MODIFIES",
            "MODIFY", "MONTH", "MULTILINESTRING", "MULTIPOINT", "MULTIPOLYGON", "MUTEX", "MYSQL_ERRNO",
            "NAME", "NAMES", "NATIONAL", "NATURAL", "NCHAR", "NDB", "NDBCLUSTER", "NESTED",
            "NETWORK_NAMESPACE", "NEVER", "NEW", "NEXT", "NO", "NODEGROUP", "NONE", "NOT",
            "NOWAIT", "NO_WAIT", "NO_WRITE_TO_BINLOG", "NTH_VALUE", "NTILE", "NULL",
            "NULLS", "NUMBER", "NUMERIC", "NVARCHAR",
            "OF", "OFF", "OFFSET", "OJ", "OLD", "ON", "ONE", "ONLY", "OPEN", "OPTIMIZE",
            "OPTIMIZER_COSTS", "OPTION", "OPTIONAL", "OPTIONALLY", "OPTIONS", "OR", "ORDER",
            "ORDINALITY", "ORGANIZATION", "OTHERS", "OUT", "OUTER", "OUTFILE", "OVER", "OWNER",
            "PACK_KEYS", "PAGE", "PARSER", "PARTIAL", "PARTITION",
            "PARTITIONING", "PARTITIONS", "PASSWORD", "PASSWORD_LOCK_TIME", "PATH",
            "PERCENT_RANK", "PERSIST", "PERSIST_ONLY", "PHASE", "PLUGIN", "PLUGINS",
            "PLUGIN_DIR", "POINT", "POLYGON", "PORT", "PRECEDES", "PRECEDING", "PRECISION",
            "PREPARE", "PRESERVE", "PREV", "PRIMARY", "PRIVILEGES", "PRIVILEGE_CHECKS_USER",
            "PROCEDURE", "PROCESS", "PROCESSLIST", "PROFILE", "PROFILES", "PROXY", "PURGE",
            "QUARTER", "QUERY", "QUICK",
            "RANDOM", "RANGE", "RANK", "READ", "READS", "READ_ONLY", "READ_WRITE",
            "REAL", "REBUILD", "RECOVER", "RECURSIVE", "REDOFILE", "REDO_BUFFER_SIZE",
            "REDUNDANT", "REFERENCE", "REFERENCES", "REGEXP", "REGISTRATION", "RELAY",
            "RELAYLOG", "RELAY_LOG_FILE", "RELAY_LOG_POS", "RELAY_THREAD", "RELEASE",
            "RELOAD", "REMOTE", "REMOVE", "RENAME", "REORGANIZE", "REPAIR", "REPEAT",
            "REPEATABLE", "REPLACE", "REPLICA", "REPLICAS", "REPLICATE_DO_DB",
            "REPLICATE_DO_TABLE", "REPLICATE_IGNORE_DB", "REPLICATE_IGNORE_TABLE",
            "REPLICATE_REWRITE_DB", "REPLICATE_WILD_DO_TABLE", "REPLICATE_WILD_IGNORE_TABLE",
            "REPLICATION", "REQUIRE", "REQUIRE_ROW_FORMAT", "RESET", "RESIGNAL", "RESOURCE",
            "RESPECT", "RESTART", "RESTORE", "RESTRICT", "RESUME", "RETAIN", "RETURN",
            "RETURNED_SQLSTATE", "RETURNING", "RETURNS", "REUSE", "REVERSE", "REVOKE",
            "RIGHT", "RLIKE", "ROLE", "ROLLBACK", "ROLLUP", "ROTATE", "ROUTINE", "ROW",
            "ROWS", "ROW_COUNT", "ROW_FORMAT", "ROW_NUMBER", "RTREE",
            "SAVEPOINT", "SCHEDULE", "SCHEMA", "SCHEMAS", "SCHEMA_NAME", "SECOND", "SECONDARY",
            "SECONDARY_ENGINE", "SECONDARY_ENGINE_ATTRIBUTE", "SECONDARY_LOAD",
            "SECONDARY_UNLOAD", "SECOND_MICROSECOND", "SECURITY", "SELECT", "SENSITIVE",
            "SEPARATOR", "SERIAL", "SERIALIZABLE", "SERVER", "SESSION", "SET", "SHARE",
            "SHOW", "SHUTDOWN", "SIGNAL", "SIGNED", "SIMPLE", "SKIP", "SLAVE", "SLOW",
            "SMALLINT", "SNAPSHOT", "SOCKET", "SOME", "SONAME", "SOUNDS", "SOURCE",
            "SOURCE_AUTO_POSITION", "SOURCE_BIND", "SOURCE_COMPRESSION_ALGORITHMS",
            "SOURCE_CONNECT_RETRY", "SOURCE_DELAY", "SOURCE_HEARTBEAT_PERIOD", "SOURCE_HOST",
            "SOURCE_LOG_FILE", "SOURCE_LOG_POS", "SOURCE_PASSWORD", "SOURCE_PORT",
            "SOURCE_PUBLIC_KEY_PATH", "SOURCE_RETRY_COUNT", "SOURCE_SSL", "SOURCE_SSL_CA",
            "SOURCE_SSL_CAPATH", "SOURCE_SSL_CERT", "SOURCE_SSL_CIPHER", "SOURCE_SSL_CRL",
            "SOURCE_SSL_CRLPATH", "SOURCE_SSL_KEY", "SOURCE_SSL_VERIFY_SERVER_CERT",
            "SOURCE_TLS_CIPHERSUITES", "SOURCE_TLS_VERSION",
            "TABLE", "TABLES", "TABLESPACE", "TABLE_CHECKSUM", "TABLE_NAME", "TEMPORARY",
            "TEMPTABLE", "TERMINATED", "TEXT", "THAN", "THEN", "THREAD_PRIORITY",
            "TIES", "TIME", "TIMESTAMP", "TIMESTAMPADD", "TIMESTAMPDIFF", "TINYBLOB",
            "TINYINT", "TINYTEXT", "TLS", "TO", "TRAILING", "TRANSACTION", "TRIGGER",
            "TRIGGERS", "TRUE", "TRUNCATE", "TYPE", "TYPES", 
            "UNBOUNDED", "UNCOMMITTED", "UNDEFINED", "UNDO", "UNDOFILE", "UNDO_BUFFER_SIZE", "UNICODE", "UNINSTALL",
            "UNION", "UNIQUE", "UNKNOWN", "UNLOCK", "UNREGISTER", "UNSIGNED", "UNTIL",
            "UPDATE", "UPGRADE", "URL", "USAGE", "USE", "USER", "USER_RESOURCES", "USE_FRM",
            "USING", "UTC_DATE", "UTC_TIME", "UTC_TIMESTAMP",
            "VALIDATION", "VALUE", "VALUES", "VARBINARY", "VARCHAR", "VARCHARACTER",
            "VARIABLES", "VARYING", "VCPU", "VIEW", "VIRTUAL", "VISIBLE",
            "WAIT", "WARNINGS", "WEEK", "WEIGHT_STRING", "WHEN", "WHERE", "WHILE",
            "WINDOW", "WITH", "WITHOUT", "WORK", "WRAPPER", "WRITE",
            "X509", "XA", "XID", "XML", "XOR",
            "YEAR", "YEAR_MONTH",
            "ZEROFILL", "ZONE"]
抓蛙师
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL8.0认证 ocp(175题)
08-30
MySQL 8.0 OCP（Oracle Certified Professional）认证是针对MySQL数据库管理员的一项专业认证，..."美河学习在线eimhe.com_MySQL8.0认证 ocp(175题) .pdf"这份资料将涵盖以上所有知识点，为备考者提供详尽的复习材料。
MySql 8.0 版本关键字
最新发布
qq845175537的博客
05-24 489
以下列表显示了与 MySQL 5.7 相比，MySQL 8.0 中删除的关键字和保留字。MySQL 8.0 移除关键字和保留字。
mysql8.0关键字_mysql8.0关键字
weixin_36098237的博客
01-28 171
ACCESSIBLE,ADD,ALL,ALTER,ANALYZE,AND,AS,ASC,ASENSITIVE,BEFORE,BETWEEN,BIGINT,BINARY,BLOB,BOTH,BY,CALL,CASCADE,CASE,CHANGE,CHAR,CHARACTER,CHECK,COLLATE,COLUMN,CONDITION,CONSTRAINT,CONTINUE,CONVERT,CREA...
MySQL 8.0中的新增功能
静静是我女朋友
04-20 2027
原文：https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/我们自豪地宣布MySQL 8.0的一般可用性。现在下载！MySQL 8.0是全球最受欢迎的开源数据库的一个非常令人兴奋的新版本，全面改进。一些关键的增强包括：SQL窗口函数，公用表表达式，NOWAIT和SKIP LOCKED，降序索引，分组，正则表达式
MySQL 关键字和保留字汇总（MySQL 8.0）
m0_56921622的博客
02-17 8339
也就是说列名设计避免关键字与保留字带引号的方式，采取前后缀，多个单词拼接等合理的方式来避免引号。关键字是在SQL中具有重要意义的单词，如果作为列名则会导致SQL语句出错。可以使用反引号来避免错误。列如：rank作为保留字，可以采用。
MySQL 8.0 关键字和保留字
lmw的博客
09-06 2208
AaACCOUNTaccountACTIONactionACTIVEactiveACTIVE;active;ADD (R)add (r)ADMINadminADMIN;admin;AFTERafterAGAINSTagainstAGGREGATEaggregateALGORITHMalgorithmALL (R)all (r)ALTER (R)alter (r)ALWAYSalwaysANALYSE;analyse;AND (R)and (r)ANY。
mysql8.0 附带一键安装脚本
12-15
这个“mysql8.0 附带一键安装脚本”可能包含了一个简化 MySQL 8.0 安装过程的自动化脚本，使得在各种操作系统上部署数据库服务器变得更加便捷。 ### MySQL 8.0 的关键特性： 1. **增强的性能**：MySQL 8.0 通过...
MySQL 8.0 Reference Manual MySQL 8.0 Reference Manual
04-09
MySQL 8.0 参考手册是 MySQL 8.0 的官方文档，涵盖 MySQL 8.0 到 8.0.30 和 NDB Cluster 8.0 的所有版本。该手册详细记录了 MySQL 8.0 的所有特性、配置选项、语法、函数和优化技巧。 MySQL 8.0 的主要特性 ...
MySQL8.0参考手册中文版
09-26
打开百度网盘，免费下载不要钱 链接：https://pan.baidu.com/s/1loAoyceuxnOLVmsW41o72g?pwd=mnzg 提取码：mnzg
MySQL 8.0 OCP应试必备指南
07-07
MySQL 8.0 OCP应试必备指南 MySQL 8.0 OCP考试内容： 在MySQL 8.0 OCP考试中，考察的内容包括rpm包安装，企业版特性和安全。其中，rpm包安装是考试的重点，包括rpm包的安装、配置和管理。企业版特性也是一大题型，...
2.4_2 MySQL8 全部数据类型
GroupiesM的博客
12-29 3728
MySQL8 全部数据类型，用于SQL获取 MySQL 映射Teradata表结构， 转自 https://www.cnblogs.com/LUA123/p/11459296.html
基于MySQL8.0 官方的关键字整理
After 95
07-09 1417
为了保持整洁和实用，此处对官方给出的关键字做了以下处理： ACCESSIBLE ® 去除 (R) ACTIVE; added in 8.0.14 (nonreserved) 去除 ; 号后面的文字 参考的官方地址：https://dev.mysql.com/doc/refman/8.0/en/keywords.html 另整理了一份关键字的数据库脚本：https://download.csdn.net/download/after95/20097607 附上关键字检查SQL SELECT inf.
mysql8关键词_mysql8.0关键字
weixin_28725037的博客
01-28 155
ACCESSIBLE,ADD,ALL,ALTER,ANALYZE,AND,AS,ASC,ASENSITIVE,BEFORE,BETWEEN,BIGINT,BINARY,BLOB,BOTH,BY,CALL,CASCADE,CASE,CHANGE,CHAR,CHARACTER,CHECK,COLLATE,COLUMN,CONDITION,CONSTRAINT,CONTINUE,CONVERT,CREA...
mysql 分组查询后，将某个字段转成数组
wcdunf的博客
05-10 3502
在 MySQL 中将分组查询后的某一个字段转成数组，可以使用函数。函数用于将某个字段的值连接起来，如果加上DISTINCT关键字，则会去除重复的值。我们可以利用这个函数来实现将某个字段的值转成数组的功能。以上 SQL 语句将products表按照category字段进行分组，并将每个分组中name字段的值连接成一个字符串，并添加了DISTINCT关键字来去除重复的值，最后别名为name_array的字段即为结果集中将name字段转成的数组。
技术分享 | 可能是目前最全的 MySQL 8.0 新特性解读(上)
杨建荣的学习笔记
03-20 791
作者：马文斌MySQL爱好者,任职于蓝月亮(中国)有限公司。本文来源：原创投稿*爱可生开源社区出品，原创内容未经授权不得随意使用，转载请联系小编并注明来源。一、功能增强1.1-所有系统表更换为InnoDB引擎系统表全部换成事务型的innodb表，默认的MySQL实例将不包含任何MyISAM表，除非手动创建MyISAM表。1.2-DDL原子化InnoDB表的DDL支持事务完整性，要么成功要么回滚，将...
mysql8 新特性总结
congge_study的博客
04-25 7719
mysql8 新特性总结
mysql8中如何在IN中使用json数组
weixin_35748962的博客
01-11 1357
在 MySQL 8 中，可以使用 JSON_ARRAY() 函数来将 JSON 数组转换为用于 IN 查询的格式。 示例： SELECT * FROM mytable WHERE JSON_EXTRACT(mycolumn, '$.id') IN (SELECT JSON_ARRAY(1, 2, 3)); 这将在 mytable 表中查询 mycolumn 中 $.id 的值为 1, 2 或 3...
MYSQL8 关键字（官方）
心有猛虎细嗅蔷薇
09-01 3453
摘自：官方 MySQL 8.0 Keywords and Reserved Words 【英文】 The following list shows the keywords and reserved words in MySQL 8.0, along with changes to individual words from version to version. Reserved keywords are marked with (R). In addition,_FILENAMEis rese..

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值