Database Administrator

MySQL slave database option log-slave-updates not enabled exception Recently, it was verified that a specific table was copied from the slave database to another master database for adjustment. If log-slave-updates is not configured, the table

Use cursor to convert the format of specified fields in the data table in Oracle (pinyin to numbers) Application Scenario: Convert [sannanyinv] In the NNDP field of the Oracle Data Table TB_USER to [3 male and 1 female] Main Script: A cursor script +

Redis Client Design The Redis client is designed as follows: /* With multiplexing we need to take per-clinet state.* Clients are taken in a liked list .*/Typedef struct redisClient {Int fd;RedisDb * db;Int dictid;Sds querybuf;Robj ** argv, ** mbargv;

MySQL read_log_event (): 'found invalid event in binary Log' MySQL is known for its ease of use. It can install N different versions on the same server to facilitate testing and migration. In addition, mysql is integrated in most Linux systems and

Oracle Import and Export (used more), oracle Import and Export1. create directory (role system/sys) create directoryHello_fileAs'D: \ dupmfile';-- View all created Directories-- Select * from dba_directories;-- Drop directory. -- Drop directory

Poor memory: 23-database transactions (1), 23- Database Transaction refers to a series of operations performed as a single logical unit of work, either completely or completely. Transaction Processing ensures that data-oriented resources are not

Log File mode in oracle and oracle Log File Mode There are two log modes in oracle Database: Non-archive log mode and archive log mode. In the oracle database system, to prevent the contents of log files from being overwritten during cyclic use, the

Comparison of Oracle Database date filtering methods and oracle Performance When developing SQL statements, filtering date segments is a common problem. How can we efficiently filter out date segments? This article demonstrates through

Oracle login uard Error: Error 1017 caught ed logging on to the standby, login uardlogging1. Status description:SQL> SELECT MESSAGE FROM V $ DATAGUARD_STATUS;MESSAGE--------------------------------------------------------------------------------ARC0:

[Shell Command] MySQL cluster global list, mysql Cluster Author: skateTime: 2015/01/19 Global list of MySQL Clusters       Usage:# Monrep-hUsage: monrep [-d dbname]-D Database Cluster name-H Display basic help# For example, if a cluster named

Step by step, gathering small streams ------ oracle easily modifies the entire row of data, ------ oracle As you learn more and more about your knowledge and discover your own shortcomings, record the knowledge you learned this time. Although

PostgreSQL introduction, postgresqlPostgreSQL Introduction: PostgreSQL is a relational database management system in the industry. It is applicable to various Linux operating systems, Windows, Solaris, BSD, and Mac OS X. PostgreSQL follows the BSD

T-SQL query: CTE, T-SQL: CTE I have seen a simple example of the with as Clause in two books. I have not found any relevant information on the Internet. Summary: [Batch update of large tables] [Batch Delete large tables] [Keep only one row for

Sqlserver calls the qq map service to obtain the city and sqlservermap Based on the location. Sqlserver calls the qq map service to obtain the City Based on the location What needs to be solved first is how to call web service in SQL SERVER,

Update all mnemonic codes and mnemonic codes Two functions are required: USE [oa erp]GO/***** Object: UserDefinedFunction [dbo]. [f_ch2py] Script Date: 12/31/2014 17:12:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].

04. Linear table (iii) chain storage structure. Single-chain table 2. Chain-chainChain storage structure. Single-chain table 2The creation of an ordered storage structure is essentially an array initialization. The storage space is continuous and

Oracle millisecond to time, oracle millisecond to time The date string for data inventory today is like this: 1.3377024E12. I wanted to use the program background to convert it and then display it on the foreground. After thinking about it, you can

Redis In-Depth Data Structure: redis Data StructureRedis main Data Structure Linked List Redis uses a C language that does not have a built-in data structure, so Redis has built its own linked list implementation. One of the underlying

MySQL uses the type varchar (20) and varchar (255) to affect the performance, mysqlvarchar1.If the index size is not limited when MySQL creates an index, the index length will use the length of this field by default, that is, varchar (20) and

Export the database structure in toad to pdm and toadpdm I. SQL statement for using toad to export the database structure: Menu [DataBase] --- [Export] ---- [Generate Schema Script], 2. In the displayed window, the frame is checked by default.