Database Administrator

Oracle delete statement optimization example When I got up to work today, I received an email from the customer saying that it took more than three hours to execute a delete SQL statement in the production environment. Finally, the customer had no

ORA-22828 input style or replacement parameter exceeds 32 K size limit The following error is reported during program debugging today: ORA-22828: input pattern or replacement parameters exceed 32 K size limit22828. 00000-"input pattern or

How MySQL uses set names to solve Garbled text We often use "set names utf8" to solve garbled code. Why can we solve this problem by adding this code? Next, let's dive into the internal execution principle of set names utf8. Let's talk about the

Creating large file tablespaces in Oracle Large file tablespace is a new tablespace type introduced in Oracle 10 GB and later versions. It is mainly used to solve the problem of insufficient storage of large files. Unlike Common tablespaces, large

Oracle table access permission Control Currently, the Oracle database has a system user SYSUSER who has permissions on all tables. The other system wants to access a table in my database. I don't want him to control all tables in my database, I

MySQL user database creation method MySQL user database creation method: Create a database bkjia, add a user named doiido with the password bkjia.com, and only have permissions on the bkjia database. 1. logon Method # Mysql-u root-p 2. Create a

Install MariaDB on CentOS 6.5 1. software environment:CentOS 6.5x64MariaDB 5.5.36 2. Installation Process1) Create the MariaDB. repo file in the/etc/yum. repos. d/directory. The content is as follows: # MariaDB 5.5 CentOS repository list-created UTC#

======== Use the source code to install the tar package, without installation -- MySQL-5.6.23 for CentOS6.5 _ 64bit ===@ guoyJoe, centos6.5mysql Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44836547 I. On the

Differences between primary key and Index 1.The primary key must be a unique index, and the unique index is not necessarily a primary key.A primary key uniquely identifies a row in a table. A table can have only one primary key, but multiple

Cannot delete or update a parent row: a foreign key constraint fails solution, constraintfails When I use the delete from table statement to clear data in a table, the following error occurs: Cannot delete or update a parent row: a foreign key

Oracle inserts 100 million data quickly, and oracle inserts million data Create a table Create table TX_TEST (id number not null, NAME VARCHAR2 (200), URL VARCHAR2 (300), POSITION VARCHAR2 (200), createtime date) Write scripts Declare --

Redis design and implementation-Sentinel Sentinel is a Redis high availability solution. It is composed of one or more Sentinel instances and can be used to monitor all the slave servers under any number of Master servers and master servers, after

Getting started with MongoDB (installation and configuration)I. Introduction A non-relational database (NoSql), MongoDB is a powerful, flexible, and Scalable Data Storage Method. Because MongoDB is a document model, it is highly flexible and

Basic MySql operation statementsDATABASE:CreateCREATTE {DATABASE | SCHEMA} [if not exists] db_name [DEFAULT] character set [=] charset_name;Delete:DROP {DATABASE | SCHEMA} [if exists] db_name;Display:SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' |

Data Source processing for an indefinite (dynamic) Report, report Dynamic Column reports are a type of dynamic reports, which are common in report applications. Because these types of reports cannot determine the number of columns in advance, they

Two effective solutions to the MySQL server has gone away problem: mysqlgone Recently, a website was designed to use the WEB page collector function. When a PHP script requests a URL, the requested webpage may be slow, exceeding the wait-timeout

Mao (xml) test multiplication (2): pl/SQL method, xmlpl Oracle supports xml. You can use pl/SQL to process xml data. The following example uses dbms_output for xml processing. Similarly, you can Insert the result into the table. Declarex xmltype: =

MySQL Chinese insert error Incorrect string value: '\ xCC \ xEC \ xB2 \ xC5', xccxecPreface:Failed to input Chinese characters, error: Incorrect string value: '\ xCC \ xEC \ xB2 \ xC5', as shown below:Mysql> set names utf8;Query OK, 0 rows affected (

Invalid ale Data Processing and constraints, and invalid ale Data ProcessingOther DML statements for data processing: Constraints Constraint is a provision** NOT NULLUNIQUEPRIMARY KEYFOREIGN KEYCHECK **You can create constraints when creating tables.

Oracle 11g installation and configuration EM, 11gem You cannot log on to EM. If you execute emca-config dbcontrol db, you do not know that the default port number is 1522. But google will execute the command in step 2... (My listeners are fine)