Database Administrator

PostgreSQL source code customization: online global read only Based on a certain functional requirement on the cloud, a function similar to MySQL global read only has been recently implemented. PostgreSQL's read only function does not need to be

Details about Reference Partition in Oracle 11g Data Partition is a solution for Big Data Objects proposed by Oracle in the early days. After the evolution of several versions, Partition is still a popular and widely used technical strategy with a

Create split and splitstr functions in Oracle It is recommended that SQL statements be created in sequence. /*************************************** Name: split* Author: sean zhang.* Date: 2012-09-03.* Function: returns the table type after a string

How to obtain the SELECT result value in a Shell script Sometimes we may need to execute the SELECT statement in the Shell script and assign the result to a variable. In this case, we can use the following methods to achieve the goal. #! /Bin/ksh##

Introduction to memcached and basic commands. Introduction to memcached commands [Introduction ]: Memcached is a high-performance distributed memory object Cache System for dynamic Web applications to reduce database load. It caches data and objects

MongoDB performs CRUD operations on images-combined with JAVA, mongodbcrud The previous blog briefly introduced how to install MongoDB, how to operate MongoDB in dos, and how to solve the errors in installing MongoDB. Of course, these are not enough.

Set STATISTICS_LEVEL = BASIC to disable database features. statisticslevel SetSTATISTICS_LEVEL=BASICWill disable the features of oracle Automatic Workload Repository (AWR) Snapshots Automatic Database Diagnostic Monitor (ADDM) All

Use CodeFirst for dynamic database creation and codefirst for dynamic database creation In the project ITOO3.0, a technical point is to dynamically create databases and tables. After a simple explanation, we will dynamically create a complete set of

Bug and SQLSERVERbugToday, the customer reported that there was a bug in ms SQL, and the problem was quite big. So we made a mark:Open the SQL query window and paste the following code: Declare @ I intset @ I = 1 while @ I 2 -- determine if 1 is

SQL with as usage and writing of recursive functions, SQL Recursion1. Meaning of WITHThe with as phrase, also known AS subquery factoring, allows you to do a lot of things and define an SQL segment, which will be used by the entire SQL statement.

[Oracle11g auto-increment primary key], oracle11g primary key Oracle Auto-incrementing primary keys must be implemented using sequences and triggers. First, we create a table where the primary key is int to implement

Oracle is not equal to the number. oracle is equal to the number. In Oracle, non-equal signs can be used in the following ways:<> ,! =, ^ =   Test SQL create table test( id int, name varchar2(10), age int)insert into test(id,name,age)

[Niuyun Video] SQL trigger and niuyun SQL trigger I learned about the data center management system. I have already written about database operations in the net version, but now I am learning about it, only to find that I have understood it

Oracle trunc () function usage, oracletrunc -- Oracle trunc () function usage/************** Date TRUNC () the function does not have second precision ********************/ Select sysdate from dual -- date at that time Select trunc (sysdate) from

General Solution for database connection failure Today, we have built a development environment. The development environment consists of two machines. My old notebook A is now used as A server dedicated to database servers. Another machine, B, is

Database paging stored procedures, supporting multi-table joint queries, paging stored procedures Database paging stored procedure, supporting multi-table joint Query Create procedure [dbo]. [getInQuiryAllByPage] @ tableNames varchar (5000), --

Semi-sync settings for m-s and semi-sync settings for m-sMaster: Install the semi-sync plug-in(System @ localhost) [(none)]> install plugin rpl_semi_sync_master soname 'semisync _ master. so ';Query OK, 0 rows affected (0.83 sec)(System @ localhost)

Mysql innodb engine's shared and independent tablespaces, mysqlinnodb For innodb data storage files, we must first solve two conceptual problems: Shared tablespace and exclusive tablespace. (The innodb engine and MYISAM engine are very different. In

Mysql group by with rollup, mysqlrollup 1. Common group by operations can be grouped BY department and position to calculate the average salary of each department and position: mysql> select dep, pos, avg (sal) from employee group by dep, pos; + ----

When the database is updated, you will suffer. Do not do this during database update. What is this? Please come with me. Earlier in the year, the customer sent the text "XX, XXXXXXXX has a 0.1 million account not received, help add it ." I