目录
1、查询MySQL 8.0关键词SQL
2、MySQL 5.7~8.0关键词列表
2.1、第1~100个
2.2、第101~200个
2.3、第201~300个
2.4、第301~400个
2.5、第401~500个
2.6、第501~600个
2.7、第601~700个
2.8、第701~755个
运行环境:
1、查询MySQL 8.0关键词SQL
以下SQL 适用于 MySQL 8.0.X 版本下执行。
-- 查看所有关键词
SELECT * FROM INFORMATION_SCHEMA.KEYWORDS;
-- 保留词(必须加 反引号 ` 才能用作标识符)
SELECT * FROM INFORMATION_SCHEMA.KEYWORDS where RESERVED = 1;
-- 非保留词(不用加 反引号 ` 即可用作标识符)
SELECT * FROM INFORMATION_SCHEMA.KEYWORDS where RESERVED = 0;
2、MySQL 5.7~8.0关键词列表
本文主要是对MySQL 5.7~8.0 关键词 和 保留词(Keywords and Reserved Words)进行 整理、合并,供有需要的码友参考。
- 保留词:必须加 反引号 ` 才能用作标识符。如 `ALL`
- 非保留词:不用加 反引号 ` 即可用作标识符
2.1、第1~100个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
1 | ACCESSIBLE | | | 是 |
2 | ACCOUNT | added in 5.7.6 (nonreserved) | | |
3 | ACTION | | | |
4 | ACTIVE | added in 8.0.14 (nonreserved) | | |
5 | ADD | | | |
6 | ADMIN | | became nonreserved in 8.0.12 | |
7 | AFTER | | | |
8 | AGAINST | | | |
9 | AGGREGATE | | | |
10 | ALGORITHM | | | |
11 | ALL | | | 是 |
12 | ALTER | | | 是 |
13 | ALWAYS | added in 5.7.6 (nonreserved) | | |
14 | ANALYSE | | removed in 8.0.1 | |
15 | ANALYZE | | | 是 |
16 | AND | | | 是 |
17 | ANY | | | |
18 | ARRAY | added in 8.0.17 (reserved) | became nonreserved in 8.0.19 | |
19 | AS | | | 是 |
20 | ASC | | | 是 |
21 | ASCII | | | |
22 | ASENSITIVE | | | 是 |
23 | AT | | | |
24 | ATTRIBUTE | added in 8.0.21 (nonreserved) | | |
25 | AUTHENTICATION | added in 8.0.27 (nonreserved) | | |
26 | AUTO_INCREMENT | | | |
27 | AUTOEXTEND_SIZE | | | |
28 | AVG | | | |
29 | AVG_ROW_LENGTH | | | |
30 | BACKUP | | | |
31 | BEFORE | | | 是 |
32 | BEGIN | | | |
33 | BETWEEN | | | 是 |
34 | BIGINT | | | 是 |
35 | BINARY | | | 是 |
36 | BINLOG | | | |
37 | BIT | | | |
38 | BLOB | | | 是 |
39 | BLOCK | | | |
40 | BOOL | | | |
41 | BOOLEAN | | | |
42 | BOTH | | | 是 |
43 | BTREE | | | |
44 | BUCKETS | added in 8.0.2 (nonreserved) | | |
45 | BY | | | 是 |
46 | BYTE | | | |
47 | CACHE | | | |
48 | CALL | | | 是 |
49 | CASCADE | | | 是 |
50 | CASCADED | | | |
51 | CASE | | | 是 |
52 | CATALOG_NAME | | | |
53 | CHAIN | | | |
54 | CHALLENGE_RESPONSE | added in 8.0.27 (nonreserved) | | |
55 | CHANGE | | | 是 |
56 | CHANGED | | | |
57 | CHANNEL | added in 5.7.6 (nonreserved) | | |
58 | CHAR | | | 是 |
59 | CHARACTER | | | 是 |
60 | CHARSET | | | |
61 | CHECK | | | 是 |
62 | CHECKSUM | | | |
63 | CIPHER | | | |
64 | CLASS_ORIGIN | | | |
65 | CLIENT | | | |
66 | CLONE | added in 8.0.3 (nonreserved) | | |
67 | CLOSE | | | |
68 | COALESCE | | | |
69 | CODE | | | |
70 | COLLATE | | | 是 |
71 | COLLATION | | | |
72 | COLUMN | | | 是 |
73 | COLUMN_FORMAT | | | |
74 | COLUMN_NAME | | | |
75 | COLUMNS | | | |
76 | COMMENT | | | |
77 | COMMIT | | | |
78 | COMMITTED | | | |
79 | COMPACT | | | |
80 | COMPLETION | | | |
81 | COMPONENT | | | |
82 | COMPRESSED | | | |
83 | COMPRESSION | added in 5.7.8 (nonreserved) | | |
84 | CONCURRENT | | | |
85 | CONDITION | | | 是 |
86 | CONNECTION | | | |
87 | CONSISTENT | | | |
88 | CONSTRAINT | | | 是 |
89 | CONSTRAINT_CATALOG | | | |
90 | CONSTRAINT_NAME | | | |
91 | CONSTRAINT_SCHEMA | | | |
92 | CONTAINS | | | |
93 | CONTEXT | | | |
94 | CONTINUE | | | 是 |
95 | CONVERT | | | 是 |
96 | CPU | | | |
97 | CREATE | | | 是 |
98 | CROSS | | | 是 |
99 | CUBE | | became reserved in 8.0.1 | 是 |
100 | CUME_DIST | added in 8.0.2 (reserved) | | 是 |
2.2、第101~200个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
101 | CURRENT | | | |
102 | CURRENT_DATE | | | 是 |
103 | CURRENT_TIME | | | 是 |
104 | CURRENT_TIMESTAMP | | | 是 |
105 | CURRENT_USER | | | 是 |
106 | CURSOR | | | 是 |
107 | CURSOR_NAME | | | |
108 | DATA | | | |
109 | DATABASE | | | 是 |
110 | DATABASES | | | 是 |
111 | DATAFILE | | | |
112 | DATE | | | |
113 | DATETIME | | | |
114 | DAY | | | |
115 | DAY_HOUR | | | 是 |
116 | DAY_MICROSECOND | | | 是 |
117 | DAY_MINUTE | | | 是 |
118 | DAY_SECOND | | | 是 |
119 | DEALLOCATE | | | |
120 | DEC | | | 是 |
121 | DECIMAL | | | 是 |
122 | DECLARE | | | 是 |
123 | DEFAULT | | | 是 |
124 | DEFAULT_AUTH | | | |
125 | DEFINER | | | |
126 | DEFINITION | added in 8.0.4 (nonreserved) | | |
127 | DELAY_KEY_WRITE | | | |
128 | DELAYED | | | 是 |
129 | DELETE | | | 是 |
130 | DENSE_RANK | added in 8.0.2 (reserved) | | 是 |
131 | DES_KEY_FILE | | removed in 8.0.3 | |
132 | DESC | | | 是 |
133 | DESCRIBE | | | 是 |
134 | DESCRIPTION | added in 8.0.4 (nonreserved) | | |
135 | DETERMINISTIC | | | 是 |
136 | DIAGNOSTICS | | | |
137 | DIRECTORY | | | |
138 | DISABLE | | | |
139 | DISCARD | | | |
140 | DISK | | | |
141 | DISTINCT | | | 是 |
142 | DISTINCTROW | | | 是 |
143 | DIV | | | 是 |
144 | DO | | | |
145 | DOUBLE | | | 是 |
146 | DROP | | | 是 |
147 | DUAL | | | 是 |
148 | DUMPFILE | | | |
149 | DUPLICATE | | | |
150 | DYNAMIC | | | |
151 | EACH | | | 是 |
152 | ELSE | | | 是 |
153 | ELSEIF | | | 是 |
154 | EMPTY | added in 8.0.4 (reserved) | | 是 |
155 | ENABLE | | | |
156 | ENCLOSED | | | 是 |
157 | ENCRYPTION | added in 5.7.11 (nonreserved) | | |
158 | END | | | |
159 | ENDS | | | |
160 | ENFORCED | added in 8.0.16 (nonreserved) | | |
161 | ENGINE | | | |
162 | ENGINE_ATTRIBUTE | added in 8.0.21 (nonreserved) | | |
163 | ENGINES | | | |
164 | ENUM | | | |
165 | ERROR | | | |
166 | ERRORS | | | |
167 | ESCAPE | | | |
168 | ESCAPED | | | 是 |
169 | EVENT | | | |
170 | EVENTS | | | |
171 | EVERY | | | |
172 | EXCEPT | | | 是 |
173 | EXCHANGE | | | |
174 | EXCLUDE | added in 8.0.2 (nonreserved) | | |
175 | EXECUTE | | | |
176 | EXISTS | | | 是 |
177 | EXIT | | | 是 |
178 | EXPANSION | | | |
179 | EXPIRE | | | |
180 | EXPLAIN | | | 是 |
181 | EXPORT | | | |
182 | EXTENDED | | | |
183 | EXTENT_SIZE | | | |
184 | FACTOR | added in 8.0.27 (nonreserved) | | |
185 | FAILED_LOGIN_ATTEMPTS | added in 8.0.19 (nonreserved) | | |
186 | FALSE | | | 是 |
187 | FAST | | | |
188 | FAULTS | | | |
189 | FETCH | | | 是 |
190 | FIELDS | | | |
191 | FILE | | | |
192 | FILE_BLOCK_SIZE | added in 5.7.6 (nonreserved) | | |
193 | FILTER | added in 5.7.3 (nonreserved) | | |
194 | FINISH | added in 8.0.27 (nonreserved) | | |
195 | FIRST | | | |
196 | FIRST_VALUE | added in 8.0.2 (reserved) | | 是 |
197 | FIXED | | | |
198 | FLOAT | | | 是 |
199 | FLOAT4 | | | 是 |
200 | FLOAT8 | | | 是 |
2.3、第201~300个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
201 | FLUSH | | | |
202 | FOLLOWING | added in 8.0.2 (nonreserved) | | |
203 | FOLLOWS | added in 5.7.2 (nonreserved) | | |
204 | FOR | | | 是 |
205 | FORCE | | | 是 |
206 | FOREIGN | | | 是 |
207 | FORMAT | | | |
208 | FOUND | | | |
209 | FROM | | | 是 |
210 | FULL | | | |
211 | FULLTEXT | | | 是 |
212 | FUNCTION | | became reserved in 8.0.1 | 是 |
213 | GENERAL | | | |
214 | GENERATED | added in 5.7.6 (reserved) | | 是 |
215 | GEOMCOLLECTION | added in 8.0.11 (nonreserved) | | |
216 | GEOMETRY | | | |
217 | GEOMETRYCOLLECTION | | | |
218 | GET | | | 是 |
219 | GET_FORMAT | | | |
220 | GET_MASTER_PUBLIC_KEY | added in 8.0.4 (reserved) | became nonreserved in 8.0.11 | |
221 | GET_SOURCE_PUBLIC_KEY | added in 8.0.23 (nonreserved) | | |
222 | GLOBAL | | | |
223 | GRANT | | | 是 |
224 | GRANTS | | | |
225 | GROUP | | | 是 |
226 | GROUP_REPLICATION | added in 5.7.6 (nonreserved) | | |
227 | GROUPING | added in 8.0.1 (reserved) | | 是 |
228 | GROUPS | added in 8.0.2 (reserved) | | 是 |
229 | GTID_ONLY | added in 8.0.27 (nonreserved) | | |
230 | HANDLER | | | |
231 | HASH | | | |
232 | HAVING | | | 是 |
233 | HELP | | | |
234 | HIGH_PRIORITY | | | 是 |
235 | HISTOGRAM | added in 8.0.2 (nonreserved) | | |
236 | HISTORY | added in 8.0.3 (nonreserved) | | |
237 | HOST | | | |
238 | HOSTS | | | |
239 | HOUR | | | |
240 | HOUR_MICROSECOND | | | 是 |
241 | HOUR_MINUTE | | | 是 |
242 | HOUR_SECOND | | | 是 |
243 | IDENTIFIED | | | |
244 | IF | | | 是 |
245 | IGNORE | | | 是 |
246 | IGNORE_SERVER_IDS | | | |
247 | IMPORT | | | |
248 | IN | | | 是 |
249 | INACTIVE | added in 8.0.14 (nonreserved) | | |
250 | INDEX | | | 是 |
251 | INDEXES | | | |
252 | INFILE | | | 是 |
253 | INITIAL | added in 8.0.27 (nonreserved) | | |
254 | INITIAL_SIZE | | | |
255 | INITIATE | added in 8.0.27 (nonreserved) | | |
256 | INNER | | | 是 |
257 | INOUT | | | 是 |
258 | INSENSITIVE | | | 是 |
259 | INSERT | | | 是 |
260 | INSERT_METHOD | | | |
261 | INSTALL | | | |
262 | INSTANCE | added in 5.7.11 (nonreserved) | | |
263 | INT | | | 是 |
264 | INT1 | | | 是 |
265 | INT2 | | | 是 |
266 | INT3 | | | 是 |
267 | INT4 | | | 是 |
268 | INT8 | | | 是 |
269 | INTEGER | | | 是 |
270 | INTERSECT | added in 8.0.31 (reserved) | | 是 |
271 | INTERVAL | | | 是 |
272 | INTO | | | 是 |
273 | INVISIBLE | | | |
274 | INVOKER | | | |
275 | IO | | | |
276 | IO_AFTER_GTIDS | | | 是 |
277 | IO_BEFORE_GTIDS | | | 是 |
278 | IO_THREAD | | | |
279 | IPC | | | |
280 | IS | | | 是 |
281 | ISOLATION | | | |
282 | ISSUER | | | |
283 | ITERATE | | | 是 |
284 | JOIN | | | 是 |
285 | JSON | added in 5.7.8 (nonreserved) | | |
286 | JSON_TABLE | added in 8.0.4 (reserved) | | 是 |
287 | JSON_VALUE | added in 8.0.21 (nonreserved) | | |
288 | KEY | | | 是 |
289 | KEY_BLOCK_SIZE | | | |
290 | KEYRING | added in 8.0.24 (nonreserved) | | |
291 | KEYS | | | 是 |
292 | KILL | | | 是 |
293 | LAG | added in 8.0.2 (reserved) | | 是 |
294 | LANGUAGE | | | |
295 | LAST | | | |
296 | LAST_VALUE | added in 8.0.2 (reserved) | | 是 |
297 | LATERAL | added in 8.0.14 (reserved) | | 是 |
298 | LEAD | added in 8.0.2 (reserved) | | 是 |
299 | LEADING | | | 是 |
300 | LEAVE | | | 是 |
2.4、第301~400个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
301 | LEAVES | | | |
302 | LEFT | | | 是 |
303 | LESS | | | |
304 | LEVEL | | | |
305 | LIKE | | | 是 |
306 | LIMIT | | | 是 |
307 | LINEAR | | | 是 |
308 | LINES | | | 是 |
309 | LINESTRING | | | |
310 | LIST | | | |
311 | LOAD | | | 是 |
312 | LOCAL | | | |
313 | LOCALTIME | | | 是 |
314 | LOCALTIMESTAMP | | | 是 |
315 | LOCK | | | 是 |
316 | LOCKED | added in 8.0.1 (nonreserved) | | |
317 | LOCKS | | | |
318 | LOGFILE | | | |
319 | LOGS | | | |
320 | LONG | | | 是 |
321 | LONGBLOB | | | 是 |
322 | LONGTEXT | | | 是 |
323 | LOOP | | | 是 |
324 | LOW_PRIORITY | | | 是 |
325 | MASTER | | | |
326 | MASTER_AUTO_POSITION | | | |
327 | MASTER_BIND | | | 是 |
328 | MASTER_COMPRESSION_ALGORITHMS | added in 8.0.18 (nonreserved) | | |
329 | MASTER_CONNECT_RETRY | | | |
330 | MASTER_DELAY | | | |
331 | MASTER_HEARTBEAT_PERIOD | | | |
332 | MASTER_HOST | | | |
333 | MASTER_LOG_FILE | | | |
334 | MASTER_LOG_POS | | | |
335 | MASTER_PASSWORD | | | |
336 | MASTER_PORT | | | |
337 | MASTER_PUBLIC_KEY_PATH | added in 8.0.4 (nonreserved) | | |
338 | MASTER_RETRY_COUNT | | | |
339 | MASTER_SERVER_ID | | removed in 8.0.23 | |
340 | MASTER_SSL | | | |
341 | MASTER_SSL_CA | | | |
342 | MASTER_SSL_CAPATH | | | |
343 | MASTER_SSL_CERT | | | |
344 | MASTER_SSL_CIPHER | | | |
345 | MASTER_SSL_CRL | | | |
346 | MASTER_SSL_CRLPATH | | | |
347 | MASTER_SSL_KEY | | | |
348 | MASTER_SSL_VERIFY_SERVER_CERT | | | 是 |
349 | MASTER_TLS_CIPHERSUITES | added in 8.0.19 (nonreserved) | | |
350 | MASTER_TLS_VERSION | added in 5.7.10 (nonreserved) | | |
351 | MASTER_USER | | | |
352 | MASTER_ZSTD_COMPRESSION_LEVEL | added in 8.0.18 (nonreserved) | | |
353 | MATCH | | | 是 |
354 | MAX_CONNECTIONS_PER_HOUR | | | |
355 | MAX_QUERIES_PER_HOUR | | | |
356 | MAX_ROWS | | | |
357 | MAX_SIZE | | | |
358 | MAX_STATEMENT_TIME | added in 5.7.4 (nonreserved) | removed in 5.7.8 | |
359 | MAX_UPDATES_PER_HOUR | | | |
360 | MAX_USER_CONNECTIONS | | | |
361 | MAXVALUE | | | 是 |
362 | MEDIUM | | | |
363 | MEDIUMBLOB | | | 是 |
364 | MEDIUMINT | | | 是 |
365 | MEDIUMTEXT | | | 是 |
366 | MEMBER | added in 8.0.17 (reserved) | became nonreserved in 8.0.19 | |
367 | MEMORY | | | |
368 | MERGE | | | |
369 | MESSAGE_TEXT | | | |
370 | MICROSECOND | | | |
371 | MIDDLEINT | | | 是 |
372 | MIGRATE | | | |
373 | MIN_ROWS | | | |
374 | MINUTE | | | |
375 | MINUTE_MICROSECOND | | | 是 |
376 | MINUTE_SECOND | | | 是 |
377 | MOD | | | 是 |
378 | MODE | | | |
379 | MODIFIES | | | 是 |
380 | MODIFY | | | |
381 | MONTH | | | |
382 | MULTILINESTRING | | | |
383 | MULTIPOINT | | | |
384 | MULTIPOLYGON | | | |
385 | MUTEX | | | |
386 | MYSQL_ERRNO | | | |
387 | NAME | | | |
388 | NAMES | | | |
389 | NATIONAL | | | |
390 | NATURAL | | | 是 |
391 | NCHAR | | | |
392 | NDB | | | |
393 | NDBCLUSTER | | | |
394 | NESTED | added in 8.0.4 (nonreserved) | | |
395 | NETWORK_NAMESPACE | added in 8.0.16 (nonreserved) | | |
396 | NEVER | added in 5.7.4 (nonreserved) | | |
397 | NEW | | | |
398 | NEXT | | | |
399 | NO | | | |
400 | NO_WAIT | | | |
2.5、第401~500个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
401 | NO_WRITE_TO_BINLOG | | | 是 |
402 | NODEGROUP | | | |
403 | NONBLOCKING | | removed in 5.7.6 | |
404 | NONE | | | |
405 | NOT | | | 是 |
406 | NOWAIT | added in 8.0.1 (nonreserved) | | |
407 | NTH_VALUE | added in 8.0.2 (reserved) | | 是 |
408 | NTILE | added in 8.0.2 (reserved) | | 是 |
409 | NULL | | | 是 |
410 | NULLS | added in 8.0.2 (nonreserved) | | |
411 | NUMBER | | | |
412 | NUMERIC | | | 是 |
413 | NVARCHAR | | | |
414 | OF | added in 8.0.1 (reserved) | | 是 |
415 | OFF | added in 8.0.20 (nonreserved) | | |
416 | OFFSET | | | |
417 | OJ | added in 8.0.16 (nonreserved) | | |
418 | OLD | added in 8.0.14 (nonreserved) | | |
419 | OLD_PASSWORD | | removed in 5.7.6 | |
420 | ON | | | 是 |
421 | ONE | | | |
422 | ONLY | | | |
423 | OPEN | | | |
424 | OPTIMIZE | | | 是 |
425 | OPTIMIZER_COSTS | added in 5.7.5 (reserved) | | 是 |
426 | OPTION | | | 是 |
427 | OPTIONAL | added in 8.0.13 (nonreserved) | | |
428 | OPTIONALLY | | | 是 |
429 | OPTIONS | | | |
430 | OR | | | 是 |
431 | ORDER | | | 是 |
432 | ORDINALITY | added in 8.0.4 (nonreserved) | | |
433 | ORGANIZATION | added in 8.0.4 (nonreserved) | | |
434 | OTHERS | added in 8.0.2 (nonreserved) | | |
435 | OUT | | | 是 |
436 | OUTER | | | 是 |
437 | OUTFILE | | | 是 |
438 | OVER | added in 8.0.2 (reserved) | | 是 |
439 | OWNER | | | |
440 | PACK_KEYS | | | |
441 | PAGE | | | |
442 | PARSE_GCOL_EXPR | added in 5.7.6 (reserved) | became nonreserved in 5.7.8 | |
443 | PARSER | | | |
444 | PARTIAL | | | |
445 | PARTITION | | | 是 |
446 | PARTITIONING | | | |
447 | PARTITIONS | | | |
448 | PASSWORD | | | |
449 | PASSWORD_LOCK_TIME | added in 8.0.19 (nonreserved) | | |
450 | PATH | added in 8.0.4 (nonreserved) | | |
451 | PERCENT_RANK | added in 8.0.2 (reserved) | | 是 |
452 | PERSIST | | became nonreserved in 8.0.16 | |
453 | PERSIST_ONLY | added in 8.0.2 (reserved) | became nonreserved in 8.0.16 | |
454 | PHASE | | | |
455 | PLUGIN | | | |
456 | PLUGIN_DIR | | | |
457 | PLUGINS | | | |
458 | POINT | | | |
459 | POLYGON | | | |
460 | PORT | | | |
461 | PRECEDES | added in 5.7.2 (nonreserved) | | |
462 | PRECEDING | added in 8.0.2 (nonreserved) | | |
463 | PRECISION | | | 是 |
464 | PREPARE | | | |
465 | PRESERVE | | | |
466 | PREV | | | |
467 | PRIMARY | | | 是 |
468 | PRIVILEGE_CHECKS_USER | added in 8.0.18 (nonreserved) | | |
469 | PRIVILEGES | | | |
470 | PROCEDURE | | | 是 |
471 | PROCESS | added in 8.0.11 (nonreserved) | | |
472 | PROCESSLIST | | | |
473 | PROFILE | | | |
474 | PROFILES | | | |
475 | PROXY | | | |
476 | PURGE | | | 是 |
477 | QUARTER | | | |
478 | QUERY | | | |
479 | QUICK | | | |
480 | RANDOM | added in 8.0.18 (nonreserved) | | |
481 | RANGE | | | 是 |
482 | RANK | added in 8.0.2 (reserved) | | 是 |
483 | READ | | | 是 |
484 | READ_ONLY | | | |
485 | READ_WRITE | | | 是 |
486 | READS | | | 是 |
487 | REAL | | | 是 |
488 | REBUILD | | | |
489 | RECOVER | | | |
490 | RECURSIVE | added in 8.0.1 (reserved) | | 是 |
491 | REDO_BUFFER_SIZE | | | |
492 | REDOFILE | | removed in 8.0.3 | |
493 | REDUNDANT | | | |
494 | REFERENCE | added in 8.0.4 (nonreserved) | | |
495 | REFERENCES | | | 是 |
496 | REGEXP | | | 是 |
497 | REGISTRATION | added in 8.0.27 (nonreserved) | | |
498 | RELAY | | | |
499 | RELAY_LOG_FILE | | | |
500 | RELAY_LOG_POS | | | |
2.6、第501~600个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
501 | RELAY_THREAD | | | |
502 | RELAYLOG | | | |
503 | RELEASE | | | 是 |
504 | RELOAD | | | |
505 | REMOTE | added in 8.0.3 (nonreserved) | removed in 8.0.14 | |
506 | REMOVE | | | |
507 | RENAME | | | 是 |
508 | REORGANIZE | | | |
509 | REPAIR | | | |
510 | REPEAT | | | 是 |
511 | REPEATABLE | | | |
512 | REPLACE | | | 是 |
513 | REPLICA | added in 8.0.22 (nonreserved) | | |
514 | REPLICAS | added in 8.0.22 (nonreserved) | | |
515 | REPLICATE_DO_DB | added in 5.7.3 (nonreserved) | | |
516 | REPLICATE_DO_TABLE | added in 5.7.3 (nonreserved) | | |
517 | REPLICATE_IGNORE_DB | added in 5.7.3 (nonreserved) | | |
518 | REPLICATE_IGNORE_TABLE | added in 5.7.3 (nonreserved) | | |
519 | REPLICATE_REWRITE_DB | added in 5.7.3 (nonreserved) | | |
520 | REPLICATE_WILD_DO_TABLE | added in 5.7.3 (nonreserved) | | |
521 | REPLICATE_WILD_IGNORE_TABLE | added in 5.7.3 (nonreserved) | | |
522 | REPLICATION | | | |
523 | REQUIRE | | | 是 |
524 | REQUIRE_ROW_FORMAT | added in 8.0.19 (nonreserved) | | |
525 | RESET | | | |
526 | RESIGNAL | | | 是 |
527 | RESOURCE | added in 8.0.3 (nonreserved) | | |
528 | RESPECT | added in 8.0.2 (nonreserved) | | |
529 | RESTART | added in 8.0.4 (nonreserved) | | |
530 | RESTORE | | | |
531 | RESTRICT | | | 是 |
532 | RESUME | | | |
533 | RETAIN | added in 8.0.14 (nonreserved) | | |
534 | RETURN | | | 是 |
535 | RETURNED_SQLSTATE | | | |
536 | RETURNING | added in 8.0.21 (nonreserved) | | |
537 | RETURNS | | | |
538 | REUSE | added in 8.0.3 (nonreserved) | | |
539 | REVERSE | | | |
540 | REVOKE | | | 是 |
541 | RIGHT | | | 是 |
542 | RLIKE | | | 是 |
543 | ROLE | | became nonreserved in 8.0.1 | |
544 | ROLLBACK | | | |
545 | ROLLUP | | | |
546 | ROTATE | added in 5.7.11 (nonreserved) | | |
547 | ROUTINE | | | |
548 | ROW | | became reserved in 8.0.2 | 是 |
549 | ROW_COUNT | | | |
550 | ROW_FORMAT | | | |
551 | ROW_NUMBER | added in 8.0.2 (reserved) | | 是 |
552 | ROWS | | became reserved in 8.0.2 | 是 |
553 | RTREE | | | |
554 | SAVEPOINT | | | |
555 | SCHEDULE | | | |
556 | SCHEMA | | | 是 |
557 | SCHEMA_NAME | | | |
558 | SCHEMAS | | | 是 |
559 | SECOND | | | |
560 | SECOND_MICROSECOND | | | 是 |
561 | SECONDARY | added in 8.0.16 (nonreserved) | | |
562 | SECONDARY_ENGINE | added in 8.0.13 (nonreserved) | | |
563 | SECONDARY_ENGINE_ATTRIBUTE | added in 8.0.21 (nonreserved) | | |
564 | SECONDARY_LOAD | added in 8.0.13 (nonreserved) | | |
565 | SECONDARY_UNLOAD | added in 8.0.13 (nonreserved) | | |
566 | SECURITY | | | |
567 | SELECT | | | 是 |
568 | SENSITIVE | | | 是 |
569 | SEPARATOR | | | 是 |
570 | SERIAL | | | |
571 | SERIALIZABLE | | | |
572 | SERVER | | | |
573 | SESSION | | | |
574 | SET | | | 是 |
575 | SHARE | | | |
576 | SHOW | | | 是 |
577 | SHUTDOWN | | | |
578 | SIGNAL | | | 是 |
579 | SIGNED | | | |
580 | SIMPLE | | | |
581 | SKIP | added in 8.0.1 (nonreserved) | | |
582 | SLAVE | | | |
583 | SLOW | | | |
584 | SMALLINT | | | 是 |
585 | SNAPSHOT | | | |
586 | SOCKET | | | |
587 | SOME | | | |
588 | SONAME | | | |
589 | SOUNDS | | | |
590 | SOURCE | | | |
591 | SOURCE_AUTO_POSITION | added in 8.0.23 (nonreserved) | | |
592 | SOURCE_BIND | added in 8.0.23 (nonreserved) | | |
593 | SOURCE_COMPRESSION_ALGORITHMS | added in 8.0.23 (nonreserved) | | |
594 | SOURCE_CONNECT_RETRY | added in 8.0.23 (nonreserved) | | |
595 | SOURCE_DELAY | added in 8.0.23 (nonreserved) | | |
596 | SOURCE_HEARTBEAT_PERIOD | added in 8.0.23 (nonreserved) | | |
597 | SOURCE_HOST | added in 8.0.23 (nonreserved) | | |
598 | SOURCE_LOG_FILE | added in 8.0.23 (nonreserved) | | |
599 | SOURCE_LOG_POS | added in 8.0.23 (nonreserved) | | |
600 | SOURCE_PASSWORD | added in 8.0.23 (nonreserved) | | |
2.7、第601~700个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
601 | SOURCE_PORT | added in 8.0.23 (nonreserved) | | |
602 | SOURCE_PUBLIC_KEY_PATH | added in 8.0.23 (nonreserved) | | |
603 | SOURCE_RETRY_COUNT | added in 8.0.23 (nonreserved) | | |
604 | SOURCE_SSL | added in 8.0.23 (nonreserved) | | |
605 | SOURCE_SSL_CA | added in 8.0.23 (nonreserved) | | |
606 | SOURCE_SSL_CAPATH | added in 8.0.23 (nonreserved) | | |
607 | SOURCE_SSL_CERT | added in 8.0.23 (nonreserved) | | |
608 | SOURCE_SSL_CIPHER | added in 8.0.23 (nonreserved) | | |
609 | SOURCE_SSL_CRL | added in 8.0.23 (nonreserved) | | |
610 | SOURCE_SSL_CRLPATH | added in 8.0.23 (nonreserved) | | |
611 | SOURCE_SSL_KEY | added in 8.0.23 (nonreserved) | | |
612 | SOURCE_SSL_VERIFY_SERVER_CERT | added in 8.0.23 (nonreserved) | | |
613 | SOURCE_TLS_CIPHERSUITES | added in 8.0.23 (nonreserved) | | |
614 | SOURCE_TLS_VERSION | added in 8.0.23 (nonreserved) | | |
615 | SOURCE_USER | added in 8.0.23 (nonreserved) | | |
616 | SOURCE_ZSTD_COMPRESSION_LEVEL | added in 8.0.23 (nonreserved) | | |
617 | SPATIAL | | | 是 |
618 | SPECIFIC | | | 是 |
619 | SQL | | | 是 |
620 | SQL_AFTER_GTIDS | | | |
621 | SQL_AFTER_MTS_GAPS | | | |
622 | SQL_BEFORE_GTIDS | | | |
623 | SQL_BIG_RESULT | | | 是 |
624 | SQL_BUFFER_RESULT | | | |
625 | SQL_CACHE | | removed in 8.0.3 | |
626 | SQL_CALC_FOUND_ROWS | | | 是 |
627 | SQL_NO_CACHE | | | |
628 | SQL_SMALL_RESULT | | | 是 |
629 | SQL_THREAD | | | |
630 | SQL_TSI_DAY | | | |
631 | SQL_TSI_HOUR | | | |
632 | SQL_TSI_MINUTE | | | |
633 | SQL_TSI_MONTH | | | |
634 | SQL_TSI_QUARTER | | | |
635 | SQL_TSI_SECOND | | | |
636 | SQL_TSI_WEEK | | | |
637 | SQL_TSI_YEAR | | | |
638 | SQLEXCEPTION | | | 是 |
639 | SQLSTATE | | | 是 |
640 | SQLWARNING | | | 是 |
641 | SRID | added in 8.0.3 (nonreserved) | | |
642 | SSL | | | 是 |
643 | STACKED | | | |
644 | START | | | |
645 | STARTING | | | 是 |
646 | STARTS | | | |
647 | STATS_AUTO_RECALC | | | |
648 | STATS_PERSISTENT | | | |
649 | STATS_SAMPLE_PAGES | | | |
650 | STATUS | | | |
651 | STOP | | | |
652 | STORAGE | | | |
653 | STORED | added in 5.7.6 (reserved) | | 是 |
654 | STRAIGHT_JOIN | | | 是 |
655 | STREAM | added in 8.0.20 (nonreserved) | | |
656 | STRING | | | |
657 | SUBCLASS_ORIGIN | | | |
658 | SUBJECT | | | |
659 | SUBPARTITION | | | |
660 | SUBPARTITIONS | | | |
661 | SUPER | | | |
662 | SUSPEND | | | |
663 | SWAPS | | | |
664 | SWITCHES | | | |
665 | SYSTEM | added in 8.0.3 (reserved) | | 是 |
666 | TABLE | | | 是 |
667 | TABLE_CHECKSUM | | | |
668 | TABLE_NAME | | | |
669 | TABLES | | | |
670 | TABLESPACE | | | |
671 | TEMPORARY | | | |
672 | TEMPTABLE | | | |
673 | TERMINATED | | | 是 |
674 | TEXT | | | |
675 | THAN | | | |
676 | THEN | | | 是 |
677 | THREAD_PRIORITY | added in 8.0.3 (nonreserved) | | |
678 | TIES | added in 8.0.2 (nonreserved) | | |
679 | TIME | | | |
680 | TIMESTAMP | | | |
681 | TIMESTAMPADD | | | |
682 | TIMESTAMPDIFF | | | |
683 | TINYBLOB | | | 是 |
684 | TINYINT | | | 是 |
685 | TINYTEXT | | | 是 |
686 | TLS | added in 8.0.21 (nonreserved) | | |
687 | TO | | | 是 |
688 | TRAILING | | | 是 |
689 | TRANSACTION | | | |
690 | TRIGGER | | | 是 |
691 | TRIGGERS | | | |
692 | TRUE | | | 是 |
693 | TRUNCATE | | | |
694 | TYPE | | | |
695 | TYPES | | | |
696 | UNBOUNDED | added in 8.0.2 (nonreserved) | | |
697 | UNCOMMITTED | | | |
698 | UNDEFINED | | | |
699 | UNDO | | | 是 |
700 | UNDO_BUFFER_SIZE | | | |
2.8、第701~755个
序号 | 关键词 | 首次引入版本 | 移除版本 | 是否为保留词 |
701 | UNDOFILE | | | |
702 | UNICODE | | | |
703 | UNINSTALL | | | |
704 | UNION | | | 是 |
705 | UNIQUE | | | 是 |
706 | UNKNOWN | | | |
707 | UNLOCK | | | 是 |
708 | UNREGISTER | added in 8.0.27 (nonreserved) | | |
709 | UNSIGNED | | | 是 |
710 | UNTIL | | | |
711 | UPDATE | | | 是 |
712 | UPGRADE | | | |
713 | USAGE | | | 是 |
714 | USE | | | 是 |
715 | USE_FRM | | | |
716 | USER | | | |
717 | USER_RESOURCES | | | |
718 | USING | | | 是 |
719 | UTC_DATE | | | 是 |
720 | UTC_TIME | | | 是 |
721 | UTC_TIMESTAMP | | | 是 |
722 | VALIDATION | added in 5.7.5 (nonreserved) | | |
723 | VALUE | | | |
724 | VALUES | | | 是 |
725 | VARBINARY | | | 是 |
726 | VARCHAR | | | 是 |
727 | VARCHARACTER | | | 是 |
728 | VARIABLES | | | |
729 | VARYING | | | 是 |
730 | VCPU | added in 8.0.3 (nonreserved) | | |
731 | VIEW | | | |
732 | VIRTUAL | added in 5.7.6 (reserved) | | 是 |
733 | VISIBLE | | | |
734 | WAIT | | | |
735 | WARNINGS | | | |
736 | WEEK | | | |
737 | WEIGHT_STRING | | | |
738 | WHEN | | | 是 |
739 | WHERE | | | 是 |
740 | WHILE | | | 是 |
741 | WINDOW | added in 8.0.2 (reserved) | | 是 |
742 | WITH | | | 是 |
743 | WITHOUT | added in 5.7.5 (nonreserved) | | |
744 | WORK | | | |
745 | WRAPPER | | | |
746 | WRITE | | | 是 |
747 | X509 | | | |
748 | XA | | | |
749 | XID | added in 5.7.5 (nonreserved) | | |
750 | XML | | | |
751 | XOR | | | 是 |
752 | YEAR | | | |
753 | YEAR_MONTH | | | 是 |
754 | ZEROFILL | | | 是 |
755 | ZONE | added in 8.0.22 (nonreserved) | | |
已上传至CSDN:MySQL5.7~8.0关键词和保留词汇总
参考