Database Administrator

Simple cold backup synchronization for Oracle databases in Linux and other Windows systems We have a financial system that focuses on the security of financial data. At the same time, we have two systems: a production environment (Linux) and an

Why NoSQL? Relational databases have become part of the computer culture due to their many advantages: Obtain persistent data Data can be persisted to the disk, and it is easy to access a small piece of data. Concurrency Relational databases have

Steps for building a MongoDB Cluster I have built a mongodb cluster many times, and there will be more or less problems each time. I will write this article for future reference. This is to build a cluster based on mongodb3.0. The steps are as

CentOS6.5 _ 64bit compile and install MySQL-5.6.23 CentOS6.5 _ 64bit compile and install MySQL-5.6.23 1. Disable the FirewallChkconfig iptables offService iptables stop 2. Download The mysqlsource code package and mysql-5.6.23.tar.gzDo not select

Oracle string truncation and splicing applications Today, someone asked me a question about Oracle string truncation and concatenation. I asked him to write an SQL statement. After reading the Problem description, I tried to solve it clearly, using

Analysis of several cases where the MySQL index will fail During the project process, it is inevitable that an index is created for MySQL, but the query is still very slow, next we will analyze the causes and solutions for this situation. Indexes

[They all say that select * is not good, ...], Select .. If you ask any experienced Database staff, they will tell you that SELECT * FROM... is not a good idea, so it is best not to use it. Today, I spent several hours testing some places

MysqlWorkBench, table creation --- shinepans, and mysqlworkbench1. Download workbench first: Http://url.cn/cVLpZ0 2. After the installation is complete, open and you will see an enabled mysql service. connect to it: 3. check your scheme:

MySQL 'root' @ 'localhost' cannot be logged on, mysqllocalhost This morning, my colleague said that the MySQL root Account could not be logged on. I tried it.# Mysql-u root-pPrompt "Access denied for user 'root' @ 'localhost' (using password: YES )"

DS sequence tables merge two non-decreasing linear tables, ds linear As early as I wrote a linear table, I mentioned this complicated operation. Today we will merge it. It is known that the data elements in the order table La and Lb are arranged in

DS sequence stack and Chain team to realize retrieval judgment and ds sequence Retrieval The basic operations of the sequence stack and the chain team will not be listed one by one. To realize the retrieval judgment, first understand what is the

(14) mysql events and 14mysql events Overview The event scheduler is a new feature after MySQL5.1. It can trigger an operation on a database according to a custom time cycle and can be understood as a time trigger,Similar to crontab in linux, or

[LeetCode] DeleteDuplicateEmails, solution report, leetcode Question SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. Id Email 1

Record is locked by another user, recordlocked This error is reported when data is updated: The table is locked because no commit exists during table operation. You can unlock the row lock by executing the following two statements.View the sid

Configure xampp + thinkphp solution in mac, xamppthinkphp I recently switched to the background for the UML course. for quick and agile development, we chose the thinkphp framework, the Chinese framework is easy to understand (this sentence is not

SQL: Composite query in Chapter 14th14.1 Combined Query Most SQL queries only contain a single SELECT statement returned from one or more tables. However, SQL and allow execution of multiple queries (multiple SELECT statements) and return the

Common query methods in oracle and common methods in oracleCommon query methods in oracleQuery all user information in oracleSelect * from dba_users;Query only users and passwordsSelect username, password from dba_users;Query current user

Import a text file to the mysql database table and insert command to insert data to the table, mysqlinsert 1. Import a text file to a database TABLE: mysql> load data local infile 'text path 'into TABLE name; example: mysql> load data local

Data Mining basics: Find the relevant project-level algorithm in the data, and mine data-level data. Ck: Candidate itemset of size kLk: frequent itemset of size kL1 = {frequent items}; for (k = 1; Lk! =; K ++) do begin Ck + 1 = candidates generated

SQL Server can concurrently obtain the maximum document number in the subscription database to test and solve the bill !, SQL Server Act Note: Many transaction systems require document numbers, and it is a headache to obtain document numbers