Database Administrator

Error logs recorded during DML Process When you insert millions of data records, the insertion fails due to several dirty data records. Oracle 10g R2 has a new feature that inserts records that failed to be inserted into another table. SQL> drop

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;

Mysqldump back up and restore a MySQL database Brief Introduction: The mysqldump command can be used to export all specified databases and tables as SQL scripts, which can be used on Mysql in different sections. For example, to upgrade the Mysql

Character set 'utf8mb4' is not a compiled character set A Character set error occurred during a recent MySQL Data migration. The prompt is "character set 'utf8mb4' is not a compiled Character set ". That is, the character set utf8mb4 is not a

Solution to ORA-01417 under Oracle 11g Today there is customer feedback, there is a SQL on 12C no problem, on Oracle 11g, the error is reported, the error content is ORA-01417: The table can be externally connected to at most one other table. This

MySQL series: innodb source code analysis-redo log recovery, innodbredo In the previous "innodb source code analysis-redo log structure", we know the basic structure and log writing steps of the redo log. How does the redo log recover data? When

10. mysql Import and Export Database, mysql Import and ExportImport and Export mysql database commands in linux1. Use the mysqldump command to export the database (Note: If this command is not available, run this command in the mysql installation

Create an oracle database, user, tablespace, role permission setting script, and oracle Database/* Divided into four steps *//* Step 2: create a temporary tablespace */Create temporary tablespace contract_tempTempfile 'd: \ oradata \

. Net operations on mssql (backup, restore, get table data, get table field information), mssql Field # Region database management // // restore and restore the database // // Save path /// public bool DataRestore (string FilePath) {string []

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

Silent oracle database installation on OEL7.0, oel7.0oracle Silent oracle database installation on OEL7.0Silent Installation is rarely used, and basically does not require Silent Installation. Xmanager is used to redirect graphics even for

Oracle arithmetic operations, oracle Arithmetic In Oracle's default installation, a SCOTT user has been created. The default password is tiger, which has four tables:Employee table (EMP), department table (DEPT), salary Registration Form and bonus

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,

03. Linear table (2) chain storage structure. Single-chain table 1, chain-chainChain storage structure. Single-chain table 11. Basic ConceptsTo express the logical relationship between each data element ai and its direct successor Data Element ai + 1

Innobackupex-based full recovery and Innobackupex-based recoveryFor full MySQL recovery, we can use Innobackupex's multiple backups and binlog to restore the database to the fault point. Here, full recovery is relative to point-in-time recovery

Simple tutorial on SQL statements in linux --- CREATE INDEX, simple tutorial --- create Index helps us quickly find the required information from the table. For example, suppose we want to find a message in a gardening book about how to plant green

[Oracle] Chapter 2 common operations, Chapter 2 of oracle Chapter 2 common ORACLE operations Modify the column information in the table: Alter table vendor_master modify (vencode varchar (20 )); Add a default value constraint to the column in the

Concatenates Oracle and MySQL strings and oraclemysql strings I. MySQLIn java, we usually use the plus sign (+) to concatenate strings. in MySQL, we can also use the plus sign (+). For example: Add test data first CREATE TABLE test( id INT,

Search for mongodb process numbers and mongodb process numbers The mongodb PID must be called for monitoring purposes, Method 1: Add pidfilepath =/var/run/mongodb. pid to the interaction file. After mongodb is restarted, Note: The PID file

Alex's Hadoop rookie Tutorial: 9th Sqoop1 exporting mysql and hadoopsqoop1 from Hbase or Hive Today we will talk about how to use sqoop to export Hbase or Hive stuff to mysql. But I want to tell you in advance Currently, sqoop cannot export data