Database Administrator

How to obtain MySQL help information When a MySQL-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is one of the effective ways to get help.

Oracle account password strength policy restrictions Oracle account password strength policy restrictions 1. the user password must contain letters, data, and special characters. (1) create a password check function Create or replace function verify_

Oracle simple script example, oracle example Oracle simple script example 1. Add a table -- Modified on: 2014.09.21 -- Modifier: Yi xiaoqun -- Modified: added the purchase payment form. DECLARE VC_STR VARCHAR2 (5000 ); VN_COUNT NUMBER; BEGIN --

MySQL master-slave replication and read-write separation, mysql master-slave read-write The so-called read/write splitting is to prepare two types of MySQL Databases in advance, one for update (master) and the other for query (slave ). When the

Environment: ORCLE 10GAn SQL statement is displayed separately. How to handle exceptions.1) Standard PL/SQL blocks containing Exception HandlingDECLARENo_Detail_record EXCEPTION;PRAGMA EXCEPTION_INIT(No_Detail_record,-20000 );V_nDetailCount

WAS cluster series (17): Operation Flow for modifying a configuration under WAS (Single Node + Cluster), was Cluster **************************************** ******************************** ****************  Original Works are from the blog of

Let's look at the database -- (4) transactions and database transactions. What is a transaction? Simply put, it is what you do or what you do. A term refers to a program execution unit that accesses and may update various data items in the database.

MySQL storage function error [Err] 1064 debugging record, err10641. An error is reported when a user creates a storage function.Create definer = 'root' @ 'localhost' FUNCTION 'stuff '(F_old varchar (1000), f_start int, f_length int, f_replace

Hadoop2.X/YARN environment setup-CentOS7.0 system configuration, centos7.0 I. Why should I choose CentOS7.0? The official CentOS 7.0.1406 version was released at 17:39:42 on January 26, July 7. I used many Linux versions. For the environment

Sqlite Study Notes 4: Create and Delete tables and sqlite Study Notes If you have done so much, isn't it just to get a few tables for data? Let's take a look at how to create a new table. 1. Create a table The basic syntax is as follows: CREATE

Create views and primary foreign keys in SQLserver, and create views in sqlserverI. background I have learned the relevant content of the database, but I have never practiced it in the form of a database. Now, when I am working on a data center, I

Chapter 1 Securing Your Server and Network (11): transparent database encryption, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

The Oracle HR example uses 10g, 11g, and oracle11g. Oracle HR example users can create 10g, 11g First, add the 10. SQL files in the attachment (see the end of the article) to this path: $ ORACLE_HOME/demo/schema/human_resources   Script

Solution-SQL Server Remote connection failure, SQL Server When the charging system of the IDC is released remotely, you must ensure that the database can be remotely connected. However, an error is usually reported during connection:   To solve

View and modify the maximum number of connections in ORACLE, and view the maximum number in oracleZookeeper Step 1: On the cmd command line, enter sqlplus Step 2: Enter the user name and password as prompted 1. view the processes and sessions

MongoDB: Gathering Pipeline, It appears in MongoDB2.2. A data aggregation framework based on data processing pipeline conceptual modeling. The document enters a multi-stage pipeline that can convert the document into clustering results. The

BIEE connects to SQLServer business data source (Linux environment), bieesqlserverBy default, the mssqlserver data driver is installed on biee11g. You do not need to reinstall the server. The configuration process is mainly based on ODBC. This

A ORA-14450 attempt to access a transactional temp table already in use, ora14450 An error occurred today when adding a field to the temporary table: ORA-14450 attempt to access a transactional temp table already inuse The reasons for improper use

Part 1 Database SQL language Data manipulation language (DML)   Data Manipulation Language,DMLIncluding insert, delete, and update statements for adding, deleting, and modifying data. The following table tb_employeeinfo is used as an example: Create

The most important part of data analysis is probably not the programming tools, analysis software, or statistical knowledge you are familiar, instead, you can understand the principles, assumptions, and limitations behind your statistical knowledge (