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

ORA-03135 connections lost contact Process ID: 0 Scenario Description:The leader callme said that the remote logon to pslql reports an error and the error message is:ORA-03135 connections lost contact Process ID: 01. Hurry to the vpn and log on to

Oracle GoldenGate (OGG) diagnostics This document briefly lists the issues that are frequently seen when using Oracle GoldenGate (OGG) and the diagnostic steps and tools. It describes the key file used to find the cause of failure for the OGG Group.

ORA-00911 error resolution instance ORA-00911, "911" looked very domineering error number, although I am still a beginner of Oracle, but every time I encounter a not seen ORA error number, there is a kind of catch-up, based on the error code, OERR,

MongoDB Series 3: MongoDB user permission operations After preliminary research on configuration and basic understanding, the following section describes MongoDB's user permission operations. Brief Introduction: Like all other databases, permission

Common listener-related errors in ALERT logs 3: troubleshooting of ORA-609 TNS-12537 and TNS-12547 or TNS-12170 TNS-12535 errors, ora-609tns-12535In the ALERT Log in 1.11G, the error ORA-609 TNS-12537 and TNS-12547 or TNS-12170 12170, 'tns-12535 and

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

Differences between common storage engines of Beckham _ mysql and the storage engine of Beckham _ mysqlStorage engine differencesBrief:1. Storage Engine2. Differences between myisam and innodb   I. Storage Engine 1. What is a storage engine? In

Oracle442 application scenarios --------- basic PL/SQL, basic plsql tutorial Bytes -----------------------------------------------------------------------------------The Application Scenario 207---231 is skipped after the backup and restoration of

SQLite Quick Start Guide 1. Introduction SQLite is an open-source embedded Relational Database Engine for SQL database with self-contained, zero configuration, and transaction support. It is highly portable, easy to use, compact, efficient, and

The seventh day of oracle learning and the seventh day of oracle LearningZookeeper 1. Review in the previous section2. Advanced PL/SQL3. oracle View4. oracle triggersObjectives:1. Master advanced PL/SQL usage (the paging Process Module and the order

The database updates multiple records with different values, updates multiple fields at the same time, and updates multiple records Requirement The following two tables are student (student table) and score (test student table) Statistics: total

Data cleansing Note: string to date: the problem caused by timestamp; note to attract Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the

If mysql has an id, set data to increase by 1. If no id exists, add it. Java month Calculation Comparison, mysql. java INSERT INTO invite_rejectlog_num (player_id,MONTH,count,last_modify_time)VALUES

Centos7 installation mariadb-10, centos7mariadb-10 : Http://mirrors.ustc.edu.cn/mariadb/mariadb-10.0.19/source/mariadb-10.0.19.tar.gz Because cmake is used, this can be installed offline. Yum install cmake Download the tar.gz file and

SQL Server database optimization practice (III), SQL Server Preface: This chapter describes how to compress logs and tables. Shrink log files -- Exploitation Exec sp_spaceused Statement to view the database size -- Right-click Database Properties

[Data Center reconstruction]-view, trigger, use of stored procedure, trigger Stored Procedure In the data room charging system, it is very troublesome to write multiple SQL statements to query multiple tables. To facilitate code writing, code

Mysql Date and Time type, mysql Date and Time Type Current_time display current time now () display current date and time type YEAR 1 byte 1901 ~ 2155 zero value 0000 DATE 4 byte 1000-01-01 ~ 9999-12-31 0 value 0000: 00: 00 TIME 3 bytes-838: 59: 59

Mysql Quick Start, mysql Quick Start 1. Download and decompress$ Wget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-5.5.42-1.el6.x86_64.rpm-bundle.tarExtract the following files:$ Tar-xvf MySQL-5.5.42-1.el6.x86_64.rpm-bundle.tarMySQL-shared-5.5.42-

Mysql common SQL statements (1) and mysqlsql statements[1] Clear TABLE statement truncate table fke_message; [2] resetting the start value of the auto-increment Field alter table fke_message auto_increment = 10001; [3] common table creation