Database Administrator

Differences between exp/imp and expdp/impdp During normal slave database and database migration, it usually takes several hours to use exp when encountering a large database, which takes a lot of time. It takes much less time for Oracle10g to use

MySQL stress testing tool mysqlslap Mysqlslap is a stress testing tool provided by MySQL. It can simulate a large number of clients operating on the database at the same time, and learn about the database performance through the result

Redis persistence OverviewRedis persistence Redis provides options for different persistence ranges: RDB persistently executes the real-time point (point-in-time) snapshot of the dataset at a specified interval. AOF records the write operation

Encrypt jdbc connections and table sensitive fields and jdbc FieldsThis article uses Jasypt to integrate with Hibernate to transparently encrypt important data such as personal data and private information, so that other users with permissions can

Build interesting applications with Go and redis, and build with goredis This article consists of four parts. The first part describes the functions, applications, and data structures of redis. The second part is to start using redis to build the

Mybatis performs batch update and mybatis performs update. For batch insert of Mybatis, visit http://ljhzzyx.blog.163.com/blog/static/384243122013536375 /. At present, if you want to update data in batches, if the update values are the same, it is

Database SQL Performance Optimization (I): Database SQL Performance Optimization Substr (hbs_bh, 5400) = '000000', optimization processing: hbs_bh like '000000' trunc (sk_rq) = trunc (sysdate), optimization processing: sk_rq> = trunc

PLSQL Developer database connection and tnsname. ora configuration, plsqltnsname. ora PLSQL Developer database connection and tnsname. ora Configuration Operating System: WIN10 Resource preparation: Find the PLSQLDeveloper _ decompressed (64-bit

In Windows 7, mysql5.7 changes the loading path and Data Location of the my. ini file, and mysql5.7my. ini Update: currently, a MySQL installer is installed on the mysql official website to manage the configuration of mysql software and migrate data.

Detailed description of the resutset interface operation instance in JDBC, jdbcresuset This article mainly shows you how to use the resutset interface in the JDBC interface. Let's take a look at the specific content. 1. Details of ResultSet

PostgreSQL automatically updates the timestamp when updating tables. When PostgreSQL updates a table, the timestamp is not automatically updated as follows: Operating System: CentOS7.3.1611 _ x64 PostgreSQL version: 9.6 Problem description When

How to solve an error in uninstalling Postgresql in Ubuntu: ubuntupostgresql Preface An error occurred while uninstalling the PostgreSQL database recently. Instead, you can troubleshoot and solve the problem step by step. Here we will share the

Steps for creating a Postgresql database in Linux: linuxpostgresql Preface PostgreSQL (also called Postgres) is a free object-relational database server (Database Management System), which is released under a flexible BSD-style license. Because the

Seven other differences between MySQL and Oracle: mysqloracle Others No. Category ORACLE MYSQL Note 1 Internal Connection changes 1,Select a. *, B. *, c. *, d .*From a, B, c, dWhere a. id = B. idAnd

Summary of the methods for reading and writing files in SQL injection, and summary of SQL Injection reading and writing Preface SQL Injection includes direct SQL injection and file read/write injection. This article describes the content of file

Explain in depth the String concatenation in SQL and explain the SQL String concatenation I. Overview I believe that in daily development, String concatenation is often required in SQL statements. Take sqlserver, oracle, and mysql databases as

Mybatis queries delay loading details and instances, and mybatis details Detailed description of Mybatis query delay loading and Examples 1.1 enable delayed Loading The delayed loading of Mybatis is for nested queries. It refers to querying only the

Differences between Having and Where in SQL and notes: sqlhaving Differences: The where clause removes rows that do not meet the where condition before grouping query results. That is, data is filtered before grouping. The where condition cannot

Examples of manual SQL injection and SQL Injection Preface This article is a basic manual SQL injection process. Basically, if you know all the knowledge points in the experiment above sqlilabs, you can take the following steps to remove your pants.

Description of SQL Injection Based on Boolean blind injection and description of SQL Boolean Boolean-based blind Injection The Web page only returns True and False. Then, Boolean blind injection is performed after SQL injection, and the relevant