Database Administrator

Use mysqldump to back up MariaDB Introduction to mysqldump backupMysqldump is a utility used by mysql to store databases. It mainly generates an SQL script, including the CREATE TABLE INSERT command required to re-CREATE a database from scratch. It

ORACLE-018: ORACLE tip 001 string processing, oracle-018oracle 1. truncate a string Oracle uses a function substr to intercept a string. The parameter is substr (string, start position, and truncation length ), For example, if the string 123,112

Class C ++ definition of non-Cyclic Chain, and loop Definition Using a linked list to implement queues has its unique advantages. The linked list allows you to flexibly Delete and add nodes. This is especially true for queues. To use ordered tables

Modify the table name and field name in an SQL statement.   Today, we have a temporary task to modify the database table name and field name in the production environment. In the past, the field names of the table names to be modified were all in

Qt implements cascading deletion of sqlite3 and qt implements sqlite31. there are two required tables: the barcode table and the product details table. The rfid in the barcode table is the rfid foreign key in the product table, you must delete the

MongoDB learning-Continuous updates and continuous mongodb Learning Refer to the MongoDB authoritative guide for more information and updates in this article. Advantages of MongoDB MongoDB has rich data models and is a

Oracle table organization and data replication, oracle table Organization 1. Copy the table structure and data to generate a new table: Create table table_name_new as select * from table_name_old; 2. copy only the table structure: Create table

Mysql Master/Slave configuration for read/write splitting and mysql Master/Slave read/write splitting In order to solve a large number of concurrent accesses to large websites, distributed load balancing is far from enough. At the data service layer

Use C language to call mysql database programming practices and skills, mysql Database Programming Today, I have compiled and used C language to call mysql database programming practices and skills for reference by other IT peers. If there are any

Database Design Skills and database skills 1. Relationship between original documents and entities   It can be a one-to-one, one-to-many, and many-to-many relationship. In general, they are a one-to-one relationship: an original document corresponds

One of the primary MongoDB series: MongoDB installation and recommended configuration; Primary mongodb Analysis The first time I heard about apsaradb for MongoDB, I must have heard a lot about it before I decided to learn about it. No matter what

Sedna performs xquery query and sedna performs xquery There is a file book. xml: The Call Of WildJack London32.5$2015-7-6Wuthering HeightsEmily Bronte40$2015-7-5 Create a books database: [root@localhost xuzhina]#se_cdb booksCreating a database

MySQL queries the SQL code for the data of this week, last week, this month, and last month. Http://www.jb51.net/article/32277.htm There are many ways to query MySQL. The MySQL query Implementation described below is to query data from this week,

MySQL technology insider-InnoDB Storage engine-Reading Notes (1), mysql-innodbMySQL technology insider-InnoDB Storage engine-Reading Notes (1) Mysql is always indispensable for php development. Blog link

HBase learning Summary (1): HBase download and installation, hbase Summary (HBase is a type of Database: Hadoop database, which is a NoSQL storage system designed to quickly read and write large-scale data at random. This article introduces the

Group function and group statistics, group function statistics Grouping Functions Grouping functions commonly used in SQL Count (): Count Max (): calculates the maximum value. Min (): Minimum value Avg (): calculates the average value. Sum (): Sum

MYSQL user creation, database creation, table creation, authorization, mysql database creation1. Create a user// Log on to MYSQL@> Mysql-u root-p@> Password// Create a userMysql> insert into mysql. user (Host, User, Password) values ('localhost',

PostgreSQL date calculation functions, postgresql Functions I. connector in each data SqlServer connector: + (plus sign) Sqlite connector:. (point) PostgreSQL connector: | (OR) II: Today, when I was computing data in PostgreSQL, I had to record a

MySQL Horizontal Split (Reading Notes) and mysql Reading Notes1. Introduction to horizontal split In general, a simple horizontal split mainly refers to distributing a table with extremely ordinary access to multiple tables according to certain

MongoDB introduction and installation, MongoDB introduction and Installation Mongo DB is a non-relational database (NoSql) that is very popular in the IT industry, and is favored by IT practitioners with flexible data storage methods. Now, we will