【转载】MySQL 8.0 Keywords and Reserved Words

最新推荐文章于 2024-04-10 21:24:46 发布
最新推荐文章于 2024-04-10 21:24:46 发布
阅读量150 收藏
点赞数
文章标签： 数据库 开发工具 json
原文链接：http://www.cnblogs.com/xiao1997/articles/10336559.html
版权

原文地址：https://dev.mysql.com/doc/refman/8.0/en/keywords.html

 

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, _FILENAME is reserved.

At some point, you might upgrade to a higher version, so it is a good idea to have a look at future reserved words, too. You can find these in the manuals that cover higher versions of MySQL. Most of the reserved words in the list are forbidden by standard SQL as column or table names (for example, GROUP). A few are reserved because MySQL needs them and uses a yacc parser.

 

A

  • ACCESSIBLE (R)

  • ACCOUNT

  • ACTION

  • ACTIVE; added in 8.0.14 (nonreserved)

  • ADD (R)

  • ADMIN; became nonreserved in 8.0.12

  • AFTER

  • AGAINST

  • AGGREGATE

  • ALGORITHM

  • ALL (R)

  • ALTER (R)

  • ALWAYS

  • ANALYSE; removed in 8.0.1

  • ANALYZE (R)

  • AND (R)

  • ANY

  • AS (R)

  • ASC (R)

  • ASCII

  • ASENSITIVE (R)

  • AT

  • AUTOEXTEND_SIZE

  • AUTO_INCREMENT

  • AVG

  • AVG_ROW_LENGTH

B

  • BACKUP

  • BEFORE (R)

  • BEGIN

  • BETWEEN (R)

  • BIGINT (R)

  • BINARY (R)

  • BINLOG

  • BIT

  • BLOB (R)

  • BLOCK

  • BOOL

  • BOOLEAN

  • BOTH (R)

  • BTREE

  • BUCKETS; added in 8.0.2 (nonreserved)

  • BY (R)

  • BYTE

C

  • CACHE

  • CALL (R)

  • CASCADE (R)

  • CASCADED

  • CASE (R)

  • CATALOG_NAME

  • CHAIN

  • CHANGE (R)

  • CHANGED

  • CHANNEL

  • CHAR (R)

  • CHARACTER (R)

  • CHARSET

  • CHECK (R)

  • CHECKSUM

  • CIPHER

  • CLASS_ORIGIN

  • CLIENT

  • CLONE; added in 8.0.3 (nonreserved)

  • CLOSE

  • COALESCE

  • CODE

  • COLLATE (R)

  • COLLATION

  • COLUMN (R)

  • COLUMNS

  • COLUMN_FORMAT

  • COLUMN_NAME

  • COMMENT

  • COMMIT

  • COMMITTED

  • COMPACT

  • COMPLETION

  • COMPONENT

  • COMPRESSED

  • COMPRESSION

  • CONCURRENT

  • CONDITION (R)

  • CONNECTION

  • CONSISTENT

  • CONSTRAINT (R)

  • CONSTRAINT_CATALOG

  • CONSTRAINT_NAME

  • CONSTRAINT_SCHEMA

  • CONTAINS

  • CONTEXT

  • CONTINUE (R)

  • CONVERT (R)

  • CPU

  • CREATE (R)

  • CROSS (R)

  • CUBE (R); became reserved in 8.0.1

  • CUME_DIST (R); added in 8.0.2 (reserved)

  • CURRENT

  • CURRENT_DATE (R)

  • CURRENT_TIME (R)

  • CURRENT_TIMESTAMP (R)

  • CURRENT_USER (R)

  • CURSOR (R)

  • CURSOR_NAME

D

  • DATA

  • DATABASE (R)

  • DATABASES (R)

  • DATAFILE

  • DATE

  • DATETIME

  • DAY

  • DAY_HOUR (R)

  • DAY_MICROSECOND (R)

  • DAY_MINUTE (R)

  • DAY_SECOND (R)

  • DEALLOCATE

  • DEC (R)

  • DECIMAL (R)

  • DECLARE (R)

  • DEFAULT (R)

  • DEFAULT_AUTH

  • DEFINER

  • DEFINITION; added in 8.0.4 (nonreserved)

  • DELAYED (R)

  • DELAY_KEY_WRITE

  • DELETE (R)

  • DENSE_RANK (R); added in 8.0.2 (reserved)

  • DESC (R)

  • DESCRIBE (R)

  • DESCRIPTION; added in 8.0.4 (nonreserved)

  • DES_KEY_FILE; removed in 8.0.3

  • DETERMINISTIC (R)

  • DIAGNOSTICS

  • DIRECTORY

  • DISABLE

  • DISCARD

  • DISK

  • DISTINCT (R)

  • DISTINCTROW (R)

  • DIV (R)

  • DO

  • DOUBLE (R)

  • DROP (R)

  • DUAL (R)

  • DUMPFILE

  • DUPLICATE

  • DYNAMIC

E

  • EACH (R)

  • ELSE (R)

  • ELSEIF (R)

  • EMPTY (R); added in 8.0.4 (reserved)

  • ENABLE

  • ENCLOSED (R)

  • ENCRYPTION

  • END

  • ENDS

  • ENFORCED; added in 8.0.16 (nonreserved)

  • ENGINE

  • ENGINES

  • ENUM

  • ERROR

  • ERRORS

  • ESCAPE

  • ESCAPED (R)

  • EVENT

  • EVENTS

  • EVERY

  • EXCEPT (R)

  • EXCHANGE

  • EXCLUDE; added in 8.0.2 (nonreserved)

  • EXECUTE

  • EXISTS (R)

  • EXIT (R)

  • EXPANSION

  • EXPIRE

  • EXPLAIN (R)

  • EXPORT

  • EXTENDED

  • EXTENT_SIZE

F

  • FALSE (R)

  • FAST

  • FAULTS

  • FETCH (R)

  • FIELDS

  • FILE

  • FILE_BLOCK_SIZE

  • FILTER

  • FIRST

  • FIRST_VALUE (R); added in 8.0.2 (reserved)

  • FIXED

  • FLOAT (R)

  • FLOAT4 (R)

  • FLOAT8 (R)

  • FLUSH

  • FOLLOWING; added in 8.0.2 (nonreserved)

  • FOLLOWS

  • FOR (R)

  • FORCE (R)

  • FOREIGN (R)

  • FORMAT

  • FOUND

  • FROM (R)

  • FULL

  • FULLTEXT (R)

  • FUNCTION (R); became reserved in 8.0.1

G

  • GENERAL

  • GENERATED (R)

  • GEOMCOLLECTION; added in 8.0.11 (nonreserved)

  • GEOMETRY

  • GEOMETRYCOLLECTION

  • GET (R)

  • GET_FORMAT

  • GET_MASTER_PUBLIC_KEY; added in 8.0.4 (reserved); became nonreserved in 8.0.11

  • GLOBAL

  • GRANT (R)

  • GRANTS

  • GROUP (R)

  • GROUPING (R); added in 8.0.1 (reserved)

  • GROUPS (R); added in 8.0.2 (reserved)

  • GROUP_REPLICATION

H

  • HANDLER

  • HASH

  • HAVING (R)

  • HELP

  • HIGH_PRIORITY (R)

  • HISTOGRAM; added in 8.0.2 (nonreserved)

  • HISTORY; added in 8.0.3 (nonreserved)

  • HOST

  • HOSTS

  • HOUR

  • HOUR_MICROSECOND (R)

  • HOUR_MINUTE (R)

  • HOUR_SECOND (R)

I

  • IDENTIFIED

  • IF (R)

  • IGNORE (R)

  • IGNORE_SERVER_IDS

  • IMPORT

  • IN (R)

  • INACTIVE; added in 8.0.14 (nonreserved)

  • INDEX (R)

  • INDEXES

  • INFILE (R)

  • INITIAL_SIZE

  • INNER (R)

  • INOUT (R)

  • INSENSITIVE (R)

  • INSERT (R)

  • INSERT_METHOD

  • INSTALL

  • INSTANCE

  • INT (R)

  • INT1 (R)

  • INT2 (R)

  • INT3 (R)

  • INT4 (R)

  • INT8 (R)

  • INTEGER (R)

  • INTERVAL (R)

  • INTO (R)

  • INVISIBLE

  • INVOKER

  • IO

  • IO_AFTER_GTIDS (R)

  • IO_BEFORE_GTIDS (R)

  • IO_THREAD

  • IPC

  • IS (R)

  • ISOLATION

  • ISSUER

  • ITERATE (R)

J

  • JOIN (R)

  • JSON

  • JSON_TABLE (R); added in 8.0.4 (reserved)

K

  • KEY (R)

  • KEYS (R)

  • KEY_BLOCK_SIZE

  • KILL (R)

L

  • LAG (R); added in 8.0.2 (reserved)

  • LANGUAGE

  • LAST

  • LAST_VALUE (R); added in 8.0.2 (reserved)

  • LATERAL (R); added in 8.0.14 (reserved)

  • LEAD (R); added in 8.0.2 (reserved)

  • LEADING (R)

  • LEAVE (R)

  • LEAVES

  • LEFT (R)

  • LESS

  • LEVEL

  • LIKE (R)

  • LIMIT (R)

  • LINEAR (R)

  • LINES (R)

  • LINESTRING

  • LIST

  • LOAD (R)

  • LOCAL

  • LOCALTIME (R)

  • LOCALTIMESTAMP (R)

  • LOCK (R)

  • LOCKED; added in 8.0.1 (nonreserved)

  • LOCKS

  • LOGFILE

  • LOGS

  • LONG (R)

  • LONGBLOB (R)

  • LONGTEXT (R)

  • LOOP (R)

  • LOW_PRIORITY (R)

M

  • MASTER

  • MASTER_AUTO_POSITION

  • MASTER_BIND (R)

  • MASTER_CONNECT_RETRY

  • MASTER_DELAY

  • MASTER_HEARTBEAT_PERIOD

  • MASTER_HOST

  • MASTER_LOG_FILE

  • MASTER_LOG_POS

  • MASTER_PASSWORD

  • MASTER_PORT

  • MASTER_PUBLIC_KEY_PATH; added in 8.0.4 (nonreserved)

  • 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 (R)

  • MASTER_TLS_VERSION

  • MASTER_USER

  • MATCH (R)

  • MAXVALUE (R)

  • MAX_CONNECTIONS_PER_HOUR

  • MAX_QUERIES_PER_HOUR

  • MAX_ROWS

  • MAX_SIZE

  • MAX_UPDATES_PER_HOUR

  • MAX_USER_CONNECTIONS

  • MEDIUM

  • MEDIUMBLOB (R)

  • MEDIUMINT (R)

  • MEDIUMTEXT (R)

  • MEMORY

  • MERGE

  • MESSAGE_TEXT

  • MICROSECOND

  • MIDDLEINT (R)

  • MIGRATE

  • MINUTE

  • MINUTE_MICROSECOND (R)

  • MINUTE_SECOND (R)

  • MIN_ROWS

  • MOD (R)

  • MODE

  • MODIFIES (R)

  • MODIFY

  • MONTH

  • MULTILINESTRING

  • MULTIPOINT

  • MULTIPOLYGON

  • MUTEX

  • MYSQL_ERRNO

N

  • NAME

  • NAMES

  • NATIONAL

  • NATURAL (R)

  • NCHAR

  • NDB

  • NDBCLUSTER

  • NESTED; added in 8.0.4 (nonreserved)

  • NEVER

  • NEW

  • NEXT

  • NO

  • NODEGROUP

  • NONE

  • NOT (R)

  • NOWAIT; added in 8.0.1 (nonreserved)

  • NO_WAIT

  • NO_WRITE_TO_BINLOG (R)

  • NTH_VALUE (R); added in 8.0.2 (reserved)

  • NTILE (R); added in 8.0.2 (reserved)

  • NULL (R)

  • NULLS; added in 8.0.2 (nonreserved)

  • NUMBER

  • NUMERIC (R)

  • NVARCHAR

O

  • OF (R); added in 8.0.1 (reserved)

  • OFFSET

  • OJ; added in 8.0.16 (nonreserved)

  • OLD; added in 8.0.14 (nonreserved)

  • ON (R)

  • ONE

  • ONLY

  • OPEN

  • OPTIMIZE (R)

  • OPTIMIZER_COSTS (R)

  • OPTION (R)

  • OPTIONAL; added in 8.0.13 (nonreserved)

  • OPTIONALLY (R)

  • OPTIONS

  • OR (R)

  • ORDER (R)

  • ORDINALITY; added in 8.0.4 (nonreserved)

  • ORGANIZATION; added in 8.0.4 (nonreserved)

  • OTHERS; added in 8.0.2 (nonreserved)

  • OUT (R)

  • OUTER (R)

  • OUTFILE (R)

  • OVER (R); added in 8.0.2 (reserved)

  • OWNER

P

  • PACK_KEYS

  • PAGE

  • PARSER

  • PARTIAL

  • PARTITION (R)

  • PARTITIONING

  • PARTITIONS

  • PASSWORD

  • PATH; added in 8.0.4 (nonreserved)

  • PERCENT_RANK (R); added in 8.0.2 (reserved)

  • PERSIST; became nonreserved in 8.0.16

  • PERSIST_ONLY; added in 8.0.2 (reserved); became nonreserved in 8.0.16

  • PHASE

  • PLUGIN

  • PLUGINS

  • PLUGIN_DIR

  • POINT

  • POLYGON

  • PORT

  • PRECEDES

  • PRECEDING; added in 8.0.2 (nonreserved)

  • PRECISION (R)

  • PREPARE

  • PRESERVE

  • PREV

  • PRIMARY (R)

  • PRIVILEGES

  • PROCEDURE (R)

  • PROCESS; added in 8.0.11 (nonreserved)

  • PROCESSLIST

  • PROFILE

  • PROFILES

  • PROXY

  • PURGE (R)

Q

  • QUARTER

  • QUERY

  • QUICK

R

  • RANGE (R)

  • RANK (R); added in 8.0.2 (reserved)

  • READ (R)

  • READS (R)

  • READ_ONLY

  • READ_WRITE (R)

  • REAL (R)

  • REBUILD

  • RECOVER

  • RECURSIVE (R); added in 8.0.1 (reserved)

  • REDOFILE; removed in 8.0.3

  • REDO_BUFFER_SIZE

  • REDUNDANT

  • REFERENCE; added in 8.0.4 (nonreserved)

  • REFERENCES (R)

  • REGEXP (R)

  • RELAY

  • RELAYLOG

  • RELAY_LOG_FILE

  • RELAY_LOG_POS

  • RELAY_THREAD

  • RELEASE (R)

  • RELOAD

  • REMOTE; added in 8.0.3 (nonreserved); removed in 8.0.14

  • REMOVE

  • RENAME (R)

  • REORGANIZE

  • REPAIR

  • REPEAT (R)

  • REPEATABLE

  • REPLACE (R)

  • 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 (R)

  • RESET

  • RESIGNAL (R)

  • RESOURCE; added in 8.0.3 (nonreserved)

  • RESPECT; added in 8.0.2 (nonreserved)

  • RESTART; added in 8.0.4 (nonreserved)

  • RESTORE

  • RESTRICT (R)

  • RESUME

  • RETAIN; added in 8.0.14 (nonreserved)

  • RETURN (R)

  • RETURNED_SQLSTATE

  • RETURNS

  • REUSE; added in 8.0.3 (nonreserved)

  • REVERSE

  • REVOKE (R)

  • RIGHT (R)

  • RLIKE (R)

  • ROLE; became nonreserved in 8.0.1

  • ROLLBACK

  • ROLLUP

  • ROTATE

  • ROUTINE

  • ROW (R); became reserved in 8.0.2

  • ROWS (R); became reserved in 8.0.2

  • ROW_COUNT

  • ROW_FORMAT

  • ROW_NUMBER (R); added in 8.0.2 (reserved)

  • RTREE

S

  • SAVEPOINT

  • SCHEDULE

  • SCHEMA (R)

  • SCHEMAS (R)

  • SCHEMA_NAME

  • SECOND

  • SECONDARY; added in 8.0.16 (nonreserved)

  • SECONDARY_ENGINE; added in 8.0.13 (nonreserved)

  • SECONDARY_LOAD; added in 8.0.13 (nonreserved)

  • SECONDARY_UNLOAD; added in 8.0.13 (nonreserved)

  • SECOND_MICROSECOND (R)

  • SECURITY

  • SELECT (R)

  • SENSITIVE (R)

  • SEPARATOR (R)

  • SERIAL

  • SERIALIZABLE

  • SERVER

  • SESSION

  • SET (R)

  • SHARE

  • SHOW (R)

  • SHUTDOWN

  • SIGNAL (R)

  • SIGNED

  • SIMPLE

  • SKIP; added in 8.0.1 (nonreserved)

  • SLAVE

  • SLOW

  • SMALLINT (R)

  • SNAPSHOT

  • SOCKET

  • SOME

  • SONAME

  • SOUNDS

  • SOURCE

  • SPATIAL (R)

  • SPECIFIC (R)

  • SQL (R)

  • SQLEXCEPTION (R)

  • SQLSTATE (R)

  • SQLWARNING (R)

  • SQL_AFTER_GTIDS

  • SQL_AFTER_MTS_GAPS

  • SQL_BEFORE_GTIDS

  • SQL_BIG_RESULT (R)

  • SQL_BUFFER_RESULT

  • SQL_CACHE; removed in 8.0.3

  • SQL_CALC_FOUND_ROWS (R)

  • SQL_NO_CACHE

  • SQL_SMALL_RESULT (R)

  • SQL_THREAD

  • SQL_TSI_DAY

  • SQL_TSI_HOUR

  • SQL_TSI_MINUTE

  • SQL_TSI_MONTH

  • SQL_TSI_QUARTER

  • SQL_TSI_SECOND

  • SQL_TSI_WEEK

  • SQL_TSI_YEAR

  • SRID; added in 8.0.3 (nonreserved)

  • SSL (R)

  • STACKED

  • START

  • STARTING (R)

  • STARTS

  • STATS_AUTO_RECALC

  • STATS_PERSISTENT

  • STATS_SAMPLE_PAGES

  • STATUS

  • STOP

  • STORAGE

  • STORED (R)

  • STRAIGHT_JOIN (R)

  • STRING

  • SUBCLASS_ORIGIN

  • SUBJECT

  • SUBPARTITION

  • SUBPARTITIONS

  • SUPER

  • SUSPEND

  • SWAPS

  • SWITCHES

  • SYSTEM (R); added in 8.0.3 (reserved)

T

  • TABLE (R)

  • TABLES

  • TABLESPACE

  • TABLE_CHECKSUM

  • TABLE_NAME

  • TEMPORARY

  • TEMPTABLE

  • TERMINATED (R)

  • TEXT

  • THAN

  • THEN (R)

  • THREAD_PRIORITY; added in 8.0.3 (nonreserved)

  • TIES; added in 8.0.2 (nonreserved)

  • TIME

  • TIMESTAMP

  • TIMESTAMPADD

  • TIMESTAMPDIFF

  • TINYBLOB (R)

  • TINYINT (R)

  • TINYTEXT (R)

  • TO (R)

  • TRAILING (R)

  • TRANSACTION

  • TRIGGER (R)

  • TRIGGERS

  • TRUE (R)

  • TRUNCATE

  • TYPE

  • TYPES

U

  • UNBOUNDED; added in 8.0.2 (nonreserved)

  • UNCOMMITTED

  • UNDEFINED

  • UNDO (R)

  • UNDOFILE

  • UNDO_BUFFER_SIZE

  • UNICODE

  • UNINSTALL

  • UNION (R)

  • UNIQUE (R)

  • UNKNOWN

  • UNLOCK (R)

  • UNSIGNED (R)

  • UNTIL

  • UPDATE (R)

  • UPGRADE

  • USAGE (R)

  • USE (R)

  • USER

  • USER_RESOURCES

  • USE_FRM

  • USING (R)

  • UTC_DATE (R)

  • UTC_TIME (R)

  • UTC_TIMESTAMP (R)

V

  • VALIDATION

  • VALUE

  • VALUES (R)

  • VARBINARY (R)

  • VARCHAR (R)

  • VARCHARACTER (R)

  • VARIABLES

  • VARYING (R)

  • VCPU; added in 8.0.3 (nonreserved)

  • VIEW

  • VIRTUAL (R)

  • VISIBLE

W

  • WAIT

  • WARNINGS

  • WEEK

  • WEIGHT_STRING

  • WHEN (R)

  • WHERE (R)

  • WHILE (R)

  • WINDOW (R); added in 8.0.2 (reserved)

  • WITH (R)

  • WITHOUT

  • WORK

  • WRAPPER

  • WRITE (R)

X

  • X509

  • XA

  • XID

  • XML

  • XOR (R)

Y

  • YEAR

  • YEAR_MONTH (R)

Z

  • ZEROFILL (R)

 

 

转载于:https://www.cnblogs.com/xiao1997/articles/10336559.html

baihe9650
关注
mysql中的关键字大全详解_mysql关键字大全
weixin_33142729的博客
01-20 5676
(int 必须 按照关键字进行格式化),如:SELECTDATE_ADD(CUR...1. Mysql 中有哪几种锁? Mysl 面试大全 1.表级锁:开销小,加锁快...MySQL语法语句大全一、SQL速成 结构查询语言(SQL)是用于查询关系数据库的标准语言,它包括若干关键字和一致的语法,便于数据库元件(如表、索引、 字段等)的建立和......关键字查找: select bId , bNa...
MySql 8.0，免费安装包下载
最新发布
06-19
MySQL 8.0是世界上最流行的开源关系型数据库管理系统（RDBMS）的最新版本，以其高效、稳定和灵活的特性而备受赞誉。本资源提供的是MySQL 8.0的免费安装包，允许用户在自己的计算机上搭建和管理MySQL服务器，无论你是...
MYSQL关键字
08-23
MY SQL 关键字 列出来所有的mysql关键字，本来是本人在建表的时候总是把字段的名称和mysql的关键字写成一样的了，所以整了个mysql关键字大全，来和大家分享下，希望搭建能够喜欢。
MySQL关键字
生命不息，折腾不止
09-18 3986
ADD ALL ALTER ANALYZE AND AS ASC ASENSITIVE BEFORE BETWEEN BIGINT BINARY BLOB BOTH BY CALL CASCADE CASE CHANGE CHAR CHARACTER CHECK COLLATE COLUMN
mysql 关键字大全
weixin_30388677的博客
03-02 292
mysql无论表名，还是字段名都应该避开mysql关键字. 如字段使用关键字，sql查询需加上` `。 查询插件，当使用关键字，会报错。 usage 转载于:https://www.cnblogs.com/jinnian18sui/p/10461547.html...
MySQL 5 —— 关键字
我有两颗糖
03-12 907
SELECT 筛选元素 SELECT colname1, colname2 FROM table_name; DISTINCT 用于过滤相同的值： SELECT DISTINCT colname FROM tablename; WHERE WHERE 可以设置筛选条件： SELECT colname1, colname2 FROM tablename WHERE condition1 AND (condition2 OR condition3); 如筛选出生日期早于 “196-01-01” 且不是
mysql 8.0中文参考手册
07-21
MySQL 8.0中文参考手册是一本详尽的指南，为用户提供关于MySQL 8.0版本的全面信息。MySQL是一个广泛使用的开源关系型数据库管理系统（RDBMS），它以其高效、稳定和易于扩展的特性而受到全球开发者的青睐。手册以中文...
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 的主要特性 ...
MySQL 8.0参考手册 Including MySQL NDB Cluster 8.0
03-27
MySQL 8.0 参考手册 Including MySQL NDB Cluster 8.0 MySQL 8.0 是当前最流行的开源关系数据库管理系统之一，本手册涵盖了 MySQL 8.0 的所有方面，包括 MySQL NDB Cluster 8.0。 MySQL 8.0 是一个功能强大且灵活的...
MySQL8.0认证 ocp(175题)
08-30
MySQL 8.0 OCP（Oracle Certified Professional）认证是针对MySQL数据库管理员的一项专业认证，..."美河学习在线eimhe.com_MySQL8.0认证 ocp(175题) .pdf"这份资料将涵盖以上所有知识点，为备考者提供详尽的复习材料。
mysql数据库关键字
09-10
mysql 关键字 NO_WRITE_TO_BINLOG NULL NUMERICNO_WRITE_TO_BINLOG NULL NUMERICNO_WRITE_TO_BINLOG NULL NUMERIC
mysql关键字
weixin_44738632的博客
01-02 908
以下是MySQL中的所有关键字，以及它们的作用说明：
mysql中的关键字
TianYuBaBy的博客
04-07 6386
MySQL是一种流行的开源关系型数据库管理系统，包含许多关键字，这些关键字在MySQL中具有特殊的含义，用于执行各种数据库操作。MySQL中的关键字非常重要，熟练掌握这些关键字可以使数据库操作更加高效、准确、灵活，增加编程和开发的效率。
【Mysql】关键字总结
weixin_73959027的博客
04-10 2019
可以结合外键来定义不同数据表之间的关系,并且可以加快数据库查询的速度.主键和记录之间的关系如同身份证和人之间的关系,它们之间是一一对应的. 主键分为两种类型:单字段主键和多字段联合主键. 在一张表中,主键是唯一的,只能有一个主键,如果有多个则是联合主键."字符串{n,}"表示至少匹配n次前面的字符;**星号''匹配前面的字符任意多次,包括0次,加号'+'匹配前面的字符至少一次，方括号"[]"指定一个字符集合,只匹配其中任意一个字符,即为所查找的文本.使用{n,}或者{n,m}来指定字符串连续出现的次数。
MySql一些关键字
lsh_li的专栏
01-06 236
[quote]smallint是短整形，2个字节，表示范围：-32768~32767。 int则是4字节整数，表示范围在正负21亿多一点。[/quote]
MySQL关键字总结
m0_56741902的博客
08-18 306
mysql关键字
MySQL数据库关键字集合
qq_40852612的博客
04-02 554
public static List<String> keyList() { String[] keys = {"ADD", "ALL", "ALTER", "ANALYZE", "AND", "AS", "ASC", "ASENSITIVE", "BEFORE", "BETWEEN", "BIGINT", "BINARY", "BLOB", "BOTH", "BY", "CALL", "CASCADE", "CASE", "CHANGE", ".
MySQL从入门到精通
热门推荐
m0_56581769的博客
03-08 1万+
Mysql各种关键字总结以及使用
IDEA Maven项目连接MySQL8.0教程
"这篇教程详细介绍了如何在IntelliJ IDEA（IDEA）的Maven项目中连接并使用MySQL 8.0数据库。适用于希望通过IDEA进行Java开发，并且需要与MySQL 8.0数据库交互的开发者。教程内容包括创建Maven项目、添加依赖、配置...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值