latin1_general_ci 多种语言的 (西欧)，不区分大小写 latin1_general_cs 多种语言的 (ISO 西欧)，区分大小写 latin1_german1_ci 德国 DIN-1 (字典序)，不区分大小写 latin1_german2_ci 德国 DIN-2，不区分大小写 latin1_spanish_ci 现代西班牙语，不区分大小写 latin1_swedish_ci 瑞典语/芬兰语，不区分大小写 AND ... 判断值满足范围 BINARY 将一个字符串转换为一个二进制字符串 & 位与 ~ 位非 [`\ `] (https://dev.mysql.com/doc/refman/5.7/en/bit- functions.html#operator_bitwise-or) 位或 ^ 按位异或 CASE case 操作符 DIV 整数除 / 除法 = 相等比较 <=> 详情参见 这里. 操作符 名 功能 描述 AND , && 逻辑 与 NOT , ! 逻辑 非 [`\ \ , OR`](https://dev.mysql.com/doc/refman/5.7/en/logical- operators.html#operator_or) 逻 辑 或 XOR 逻辑 亦或 逻辑操作符 操作符 - 114 - 本文档使用 书栈(BookStack.CN) 构建

imple‐ mentation can be replaced by pluggable way. It includes query optimizer, distributed transaction en‐ gine, distributed execution engine, authority engine and scheduling engine. L2 Feature Layer Used alt_agg3(int) OWNER TO regress_alter_generic_user2; CREATE CONVERSION alt_conv1 FOR ‘LATIN1’TO ‘UTF8’FROM iso8859_1_to_utf8; CREATE FOREIGN DATA WRAPPER alt_fdw1 CREATE SERVER alt_fserv1 FOREIGN DATA WRAPPER alt_agg3(int) OWNER TO regress_alter_generic_user2; CREATE CONVERSION alt_conv1 FOR ‘LATIN1’TO ‘UTF8’FROM iso8859_1_to_utf8; CREATE FOREIGN DATA WRAPPER alt_fdw1 CREATE SERVER alt_fserv1 FOREIGN DATA WRAPPER

imple‐ mentation can be replaced by pluggable way. It includes query optimizer, distributed transaction en‐ gine, distributed execution engine, authority engine and scheduling engine. L2 Feature Layer Used alt_agg3(int) OWNER TO regress_alter_generic_user2; CREATE CONVERSION alt_conv1 FOR ‘LATIN1’TO ‘UTF8’FROM iso8859_1_to_utf8; CREATE FOREIGN DATA WRAPPER alt_fdw1 CREATE SERVER alt_fserv1 FOREIGN DATA WRAPPER alt_agg3(int) OWNER TO regress_alter_generic_user2; CREATE CONVERSION alt_conv1 FOR ‘LATIN1’TO ‘UTF8’FROM iso8859_1_to_utf8; CREATE FOREIGN DATA WRAPPER alt_fdw1 CREATE SERVER alt_fserv1 FOREIGN DATA WRAPPER

Y e s Type of job execution, the value options are NORMAL_TRIGGER, MIS- FIRE, FAILOVER. s har din g_i tem VA RC HA R( 25 5) Y e s Collection of sharding item, multiple sharding items are separated

capabilities across data sources, simpli‐ fying the data aggregation from different data locations. Da ta En cr yp ti on Data Encryption is a basic way to ensure data security. ShardingSphere provides a com‐ please refer to the built-in sharding algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/sharding/ 9.1. ShardingSphere-JDBC 83 Apache ShardingSphere please refer to the built-in encryption algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/encrypt/ type: xxx props: xxx: xxx Read/Write Splitting

capabilities across data sources, simpli‐ fying the data aggregation from different data locations. Da ta En cr yp ti on Data Encryption is a basic way to ensure data security. ShardingSphere provides a com‐ please refer to the built-in sharding algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/sharding/ type: xxx props: xxx: xxx Encryption encryptors: please refer to the built-in encryption algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/encrypt/ type: xxx props: xxx: xxx 9.1. ShardingSphere-JDBC

analyzing complex data across data sources, simplifying and improving the data usage experience. Data En‐ cryp‐ tion Data Encryption is a basic way to ensure data security. ShardingSphere provides a set please refer to the built-in sharding algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/sharding/ type: xxx props: xxx: xxx Encryption encryptors: please refer to the built-in encryption algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/encrypt/ type: xxx props: xxx: xxx 4.1. ShardingSphere-JDBC

capabilities across data sources, simpli‐ fying the data aggregation from different data locations. Data En‐ cryp‐ tion Data Encryption is a basic way to ensure data security. ShardingSphere provides a com‐ please refer to the built-in sharding algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/sharding/ type: xxx props: xxx: xxx Encryption encryptors: please refer to the built-in encryption algorithm: https:// shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin- algorithm/encrypt/ type: xxx props: xxx: xxx 4.1. ShardingSphere-JDBC

myview; Making liberal use of views is a key aspect of good SQL database design. Views allow you to en- capsulate the details of the structure of your tables, which may change as your application evolves There is a second kind of identifier: the delimited identifier or quoted identifier. It is formed by en- closing an arbitrary sequence of characters in double-quotes ("). A delimited identifier is always 8.5.1. Date/Time Input Date and time input is accepted in almost any reasonable format, including ISO 8601, SQL-compatible, traditional POSTGRES, and others. For some formats, ordering of month, day, and

8.5.1. Date/Time Input Date and time input is accepted in almost any reasonable format, including ISO 8601, SQL-compatible, traditional POSTGRES, and others. For some formats, ordering of month, day, and Date Input Example Description January 8, 1999 unambiguous in any datestyle input mode 1999-01-08 ISO 8601; January 8 in any mode (recommended format) 1/8/1999 January 8 in MDY mode; August 1 in DMY mode error in YMD mode Jan-08-99 January 8, except error in YMD mode 19990108 ISO 8601; January 8, 1999 in any mode 990108 ISO 8601; January 8, 1999 in any mode 1999.008 year and day of year J2451187 Julian