Database Administrator

Oracle-provides dynamic result sets for subqueries We have encountered such a requirement: to input a String for the method, such as "User ID0, user ID1, user ID2... ", then return a result set based on these IDs as a data table for query by

XtraBackup online MySQL Master/Slave deployment 1 [Preface] There are many master-slave deployment methods for MySQL. The most common method is mysqldump. As we all know, mysqldump has two major disadvantages: 1. The master database needs to lock

Oracle 11g rac crs disk recovery after loss I. Overview In order to facilitate the test of related problems, I set up a RAC environment on the local machine. However, after opening the environment yesterday, I found that RAC could not be started.

Mysql Development --- get 01 on a daily basis, mysql --- 01 July 7, 2015 ------------------------- 1. The truncate table clears the auto_increment value of the table creation statement. the id of a table is the primary key and auto-increment. You

Create a C3P0 data source, [Author]: kwu When creating a C3P0 data source, there are very few connections to the database using JDBC in actual development. Generally, the data source is used. C3P0 is an open source data source, and the actual

Golang Custom Data Type query and insertion of point data in postgresql, golangpostgresqlGolang Custom Data Type query and insertion of point data in postgresql The Code is as follows: Package mainimport ("bytes" "database/SQL" "database/SQL/driver"

Sqldatabase optimization: cutting, database connection pool-[Examination System], sqldatabase connection As mentioned in the previous article, developers need to pay attention to cpu and memory. SQL logs cannot be ignored. SQL logs show the error

Pinot architecture introduction, pinot Architecture1. High Level Architecture1. Purpose: To provide analysis services for a given dataset2. Input data: Hadoop & Kafka3. Indexing Technology: to provide fast queries, Pinot uses column-based storage

MySQL isolation level, mysql isolation 1. read uncommitted, read uncommitted. Transaction A can read the data modified but not committed by transaction B. Dirty read 2. read committed, read committed. Transaction A can only read the data committed

Oracle-based SQL Optimization Methodology and oraclesql methodologyThe ultimate goal of SQL Optimization in Oracle databases is to shorten the execution time of target SQL statements. To achieve the above purpose, we usually have the following three

One SQL Optimization for Mysql (2) and one SQL Optimization for mysqlAfter development, I checked my adjustments and found that the index I created was actually created in another test database (Test Database 2). Why is the test database 2 still

Add, delete, modify, and query mysql instances Command for adding data to a table: mysql>insert into table_name (field1, filed2, ... fieldN) -> values(value1, value2, ...valueN); If the string type is inserted, it must be enclosed by quotation

MySQL entry (2), mysql entry For more information about this study, see MySQL required and the official Manual MySQL 5.6 Reference Manual. MySQL (1)MySQL (3)Content:-MySQL join table-MySQL ViewIv. MySQL join table Assume that you want to store the

Use JDBC to connect to the MySQL database-Typical Case Analysis (8)-implement paging query of employee data, jdbcmysql Reprinted Please note: http://blog.csdn.net/uniquewonderq Problem: Use JDBC to connect to the Mysql database and implement the

SQL Structured Query Language and basic Mysql operations, Structured Query Language SQL Structured SQL Query Language Data operation (Management) language (DML, DataManipulationLanguage) (DQL + DML)DQL query: obtain data.DML management: add, delete,

Create the PSU 11.2.0.3.8, and then the database, 11.2.0.3.8psu. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. SQL> select created from v $ database; CREATED --------------------------------------- -------------

RecycleBin, oraclerecyclebinSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionSQL>!

Mysql saves the result to a file and executes SQL statements from the file to record the operation process (using the tee command), sqltee 1. Sometimes we may need to record our mysql operation process. In this case, we can use the mysql tee command.

Use the API to convert the unknown incoming amount of AR receipts to the unverified status. apiar DECLARE p_api_version NUMBER; required VARCHAR2 (200); p_commit VARCHAR2 (200); Limit NUMBER; x_return_status VARCHAR2 (200); x_msg_count NUMBER; x_msg_

MYSQL design optimization and mysql Design This article describes how to optimize mysql from various aspects.1. Optimize SQL statements (1) locate the SQL statements to be optimized (1) count the frequency of SQL statements using show