PHP

Recently, I have been studying mysql clusters and have to install and deploy at least two or more mysql databases. This is troublesome and time-consuming. Today I wrote a Shell script based on the Installation Steps, you only need to execute the

A foreign key definition: 't_girl '. 'tb1 'straint' fk _ 1 'FOREIGNKEY ('R _ id') REFERENCES 'tb1' ('id') ONDELETECASCADE is used to restrict another field of the user. A foreign key definition: 't_girl '. 'tb1 'straint' fk _ 1 'FOREIGNKEY ('R _ id')

Recently, the company was using the postgresql database and developed many ddldml statements for us. So I spent two days completing this script to Create Table spaces and users, script for automatic data import #! Binbas Recently, the company was

Trigger is so important in the past 10 years, that is, during the period when stored procedures and ado.net dominate the world. Now, trigger is not so necessary. We will write complex services in SQL, of course, there will be no chance to write it

In fact, how to perform DBCCCHECKDB operations in a large database with table partitions has already been discussed by instructor Xu in SQLSERVER enterprise platform management practices, however, I want to talk about the notes in my own language.

Before reading this article, you can take a look at the ghost index in SQLSERVER to learn about the ghost history in SQLSERVER. About the ghost history. About the ghost history. 2. delete a record in the table. when, the corresponding records on the

The Mail System postfix + extmail + mysql based on virtual accounts has the following features: 1. support web Access 2. free account registration 3. supports network disks and personalized settings. 4. virtual account The Mail System postfix +

Operating System: AIX6.1Oracle database version: 11.1.0.7.01, when using expdp export, reported ORA-04030: outofprocessmemorywhentryingto & nb .. Operating System: AIX6.1Oracle database version: 11.1.0.7.01, when using expdp export, reported ORA-0403

Objective: To detect the recovery availability of oracle Hot Standby files (including spfiles, control files, data files, archived logs, and non-rman files) in windows from different machines and non-original paths. Test environment: windows2003R2,

Studying a project code made by someone else, we can see that there is a piece of stored procedure calling code in the database. The original code is complicated. So I plan to write a simple example to learn it. 1. Create a stored procedure to be

The reason for putting constraints and indexes together is mainly because of primary key constraints and unique key constraints. They will automatically create a corresponding index. Let's look at the constraints in the database. 1. Constraints in

Recently, a problem occurs: ASMdiskgroup cannot be mounted. After analysis, it is found that there will be a problem quickly, but because there is no backup, there is no way to recreate diskgroup and restore from backup -- so .... backup Recently, a

The recent customer email description failed to connect to the database from the client with the error code: ORA-12537: TNS: connectionclosed, and the connection was closed. Directly via tnsping without any The recent customer email description

OracleIndex and null, where 1 can be any number or letter. In this case, the predicate of the select statement does not need to be changed, or t_nameisnull. Oracle Index and null research. Here 1 can be any number or letter. In this case, the

The logon method is similar to the sqlplusassysdba command in Oracle. The difference is that when non-installation users log on in this way, Oracle returns The logon method is similar to the sqlplus/as sysdba command in Oracle. The difference is

CURDATE () or CURRENT_DATE () returns the current date in the format of ldquo; YYYY-MM-DDrdquo; or ldquo; YYYYMMDDldquo. Contains only the year, month, and day CURDATE () or CURRENT_DATE () returns the current date in the format of ldquo;

What is an error buffer? In MySQL, the Error Buffer only records the last error. If a new error is generated, the old one will be overwritten. So if you want to know what errors are generated, you have What is an error buffer? In MySQL, the Error

The memory applied for by the database from the operating system can be divided into two parts: 1. cache pool memory (data page and idle page) 2. non-Cache pool memory (thread DLL connection server, etc ). in the database, how to set and adjust

First, our question is: Why do we need to modify the etchosts file when deploying the OracleRAC? Or specifically, when we deploy OracleRAC on the Linux platform First, our question is: Why do we need to modify the/etc/hosts file when deploying

An old test AIX server was ignored. Recently, Oracle was full. Cleaned up. Version: Oracle10gR2forAIX An old test AIX server was ignored. Recently, Oracle was full. Cleaned up. Version: Oracle 10gR2 for AIX An old test AIX server, no one cares