Database Administrator

Use the FILTER, COMPUTE, and sqlexec commands in GoldenGate. This article mainly introduces the usage of some filtering or computing functions in OGG and the basic usage of sqlexec. SQLPREDICATE When initializing with OGG, you can add this parameter

Default MySQL test Database Permissions By default, the mysql. db table contains rows that allow any user to access databases starting with "test" and "test. The value of the User field in these rows is null, indicating matching any User. This means

Installing Oracle 11g R2 in LinuxI. installation environment Linux Server: CentOS 6.4 64-bit Oracle Server: Oracle 11gR2 64-bitIi. System Requirements Requirements for installing Oracle in Linux System Requirements Description

Online Slave reports 1062 Cases Recently, the online Slave often reported a 1062 error. It broke the ground. Fortunately, Slave has not been used in the business for the time being. That is to say, there is no read/write splitting, so Slave has

Redis cluster creation and deployment documentation Redis cluster creation and deployment documentation 1. Install dependencies (not always install so many dependencies. I have installed mysql and php in my environment, so I didn't need to test the

Basic Introduction to Oracle and common SQL * PLUS commands Run Database Configuration Assistant as an administrator to create a Database instance. To use Oracle, you must first start the Oracle service, find the service in the task manager, and

MySQL Internal-InnoDB Storage engine (row structure) Three parts of InnoDB Row Storage (Description: Number of columns in the F branch table) Name) Size) Field Start Offsets (F * 1) or (F * 2) bytes Extra Bytes 6

MySQL new features-mysql_config_editor encryption algorithm and Decryption Implementation Mysql_config_editor adopts aes ecb encryption. The ECB encryption of AES is usually block encryption. to encrypt data that exceeds the block size, the padding

SQL statement for querying Oracle table data by PAGE The SQL syntax for querying Oracle data by page is widely used on the Internet. This article is also a typical syntax for the author to search on the Internet. It is not my original one and is

Definition formats of basic Oracle statements Oracle built-in data typesI. character data1. char (size)2. varchar2 (size) is the most commonly used, with a maximum length of 4000 bytes.3. nvhar (size) and nvarchar (size)4. varchar (size)5. We

ASM management-how to rename diskgroup The new diskgroup rename function is added in ASM 11.2.0.1. You can use the renamedg command to rename the created diskgroup. Before renaming, you must first dismount diskgroup. If the renamed diskgroup is

MySQL InnoDB table-Basic BTree Data Structure MySQL InnoDB table is an index organization table. This should be the first thing that anyone who learns MySQL will learn. This means that the data in this table is stored in the primary key order, that

An example of ORA-00600 troubleshooting Executing a query in the database throws a ORA-00600 error exception ORA-00600: internal error code, arguments: [kcbzibmlt_lobds_1], [], [], [], [], [], [], [], [] [], [] View related trace files DDE: Problem

Commonly used sQlite statements and the use and registration of sQlite developer, sqlitedeveloper Preface SQlite is a lightweight database commonly used in development. Generally, it only occupies several hundred KB of memory space. Therefore, in

MyBatis is used to obtain the auto-generated primary key Id and instance code. MyBatis obtains the auto-generated primary key Id and instance code. When using a MySQL database, we generally use the auto-incrementing primary key of the database to

Mybatis calls the PostgreSQL stored procedure to implement array input parameter transfer. mybatispostgresql Preface Mybatis is used in the project to call operations related to the PostgreSQL Stored Procedure (custom function). Because PostgreSQL

Use ESCAPE to define escape characters in SQL. Use ESCAPE to define ESCAPE characters When the LIKE keyword is used for fuzzy search, "%", "_", and "[]" appear separately, and are considered as wildcards. To check whether there are percent (%),

[C3p0] Article 2: Using c3p0,Preface According to the c3p0-0.9.5.1 version of the official documents, coupled with their own understanding, compiled into the translation. Limited capabilities. If the translation content is incorrect or your

Error code: 1066 Not unique table/alias: 'C', 1066 unique 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT (select concat (s. name, '/', sr. reame, '[', DATE_FORMAT (. startTime, '% Y-% m-% D'),'] ') FROM

In 2015, the xinxing Redis tutorial was released, which is the win version of Oracle and Xinxing redis.Recently, thanks to the busy schedule, the Xin Xing tutorial has been suspended for a longer period of time. I am sorry here, but many of my