. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 5.1.2 ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 5.1.3 GovernanceWatcher . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 295 5.2 Configuration . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 320 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 320 5.1.2 ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 5.1.3 GovernanceWatcher . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 322 5.2 Configuration . . . . .

tidb_audit_enabled = 0; admin plugins enable audit; admin plugins disable audit; The number of audit event classes for one SQL statement One or more One Modify the auditing objects Create the filter by using Event Classes based on the type of SQL statements. A SQL statement corresponds to one or more event classes. One event class can be a subclass of another event class. For example: ● The event classes for ● The event classes for INSERT INTO t VALUES (1),(2),(3) are QUERY, QUERY_DML and INSERT. QUERY_DML is a subclass of QUERY, and INSERT is a subclass of QUERY_DML. ● The event classes for SET GLOBAL

.............................................................................. 680 RDB$SECURITY_CLASSES ................................................................................................ Запрос с двумя подзапросами: SELECT p.fullname, (SELECT name FROM classes c WHERE c.id = p.class) AS class, (SELECT name FROM mentors m WHERE m.id = p.mentor) AS вместо подзапросов: SELECT p.fullname, c.name AS class, m.name AS mentor FROM pupils p JOIN classes c ON c.id = p.class JOIN mentors m ON m.id = p.mentor

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 468 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469 10.1.2 ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 470 vii 10.2 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 471 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 472 10.2.2 SQLStatementVisitorFacade

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 440 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 441 10.1.2 ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 441 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 442 10.2 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 443 Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 444 10.2.2 SQLStatementVisitorFacade

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 740 RDB$SECURITY_CLASSES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 'Birne' similar to 'Birr%ne' -- false Notice how ‘%’ also matches the empty string. Character Classes A bunch of characters enclosed in brackets define a character class. A character in the string true 'Datte' similar to 'Dat[bcg-km-pwz]e' -- false Predefined Character Classes The following predefined character classes can also be used in a class definition: [:ALPHA:] Latin letters a..z and

————————————————————————————— 10 【更多 Java – Android 资料下载，可访问尚硅谷（中国）官网 www.atguigu.com 下载区】 public class Classes { private int id; private String name; private Teacher teacher; } 4). 定义 sql 映射文件 ClassMapper from class c, teacher t where c.teacher_id=t.t_id and c.c_id=#{id} resultMap="ClassResultMap2"> select * from class where c_id=#{id}

准备简单的数据： CREATE TABLE students ​(​id ​int​,​ name text​)​ DISTRIBUTED BY ​(​id​); CREATE TABLE classes​(​id ​int​,​ classname text​,​ student_id ​int​)​ DISTRIBUTED BY ​(​id​); INSERT INTO students VALUES VALUES ​(​1​,​ ​'​steven​'),​ ​(​2​,​ ​'​changchang​'),​ ​(​3​,​ ​'​guoguo​'); INSERT INTO classes VALUES ​(​1​,​ ​'​math​',​ ​1​),​ ​(​2​,​ ​'​math​',​ ​2​),​ ​(​3​,​ ​'​physics​',​ ​3​); 以下面的SQL为例子，了解 ​classname FROM students s​,​ classes c WHERE s​.​id​=​c​.​student_id 3.1 查询计划 其对应的查询计划如下所示： test=# explain SELECT s.name student_name, c.classname test-# FROM students s, classes c test-# WHERE s.id=c

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 495 RDB$SECURITY_CLASSES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Notice how ‘%’ also matches the empty string. Chapter 4. Common Language Elements 68 Character Classes A bunch of characters enclosed in brackets define a character class. A character in the string true 'Datte' similar to 'Dat[bcg-km-pwz]e' -- false Predefined Character Classes The following predefined character classes can also be used in a class definition: [:ALPHA:] Latin letters a..z and