Database Administrator

Oracle 11gR2 uses RMAN to copy full-database records Oracle 11gR2 uses RMAN to copy full-database records TNS and listener are configured on the source and target ends (11g dynamic listening sys cannot log on in nomount status, and static listening

MySQL database Constraints Database constraints:A constraint is a data validation rule enforced on a table. It is mainly used to ensure data integrity in the database.In addition, when the data in the table is mutually dependent, the related data is

UPDATE of MySQL lock Learning I have been learning MySQL for quite a long time and can stay in a state where I can work but I am not proficient. In addition, many MySQL knowledge points are affected by SQL Server's understanding bias. I can only

Summary of causes of index failure in Mysql and summary of index failure in mysql Http://blog.csdn.net/hehexiaoxia/article/details/54312130 When performing queries in a database, you often find that the query is slow, but you have already created

13 Tuesday course 2018.01.15 mysql user management, common SQL statements, mysql database backup and recovery, 13.4 mysql user management By default, mysql has a root user, but the root directory permission is too high, which is dangerous.

Solve the problem that inventory is reduced to negative in the case of concurrency, and the inventory is negative. Scenario: If a commodity is in stock, check the inventory before placing the order. If it is greater than 0, place inventory-1 and

In-depth understanding of MySQL 5.7 GTID series (1) and mysqlgtid Author:Gao Peng (Eight monsters in Chongqing) Original article address: Http://www.jianshu.com/p/87f66cdeb49c A total of 10 articles will be published this time. The source code

Common SQLite database statements and how to use SQLite visualization tool MeasSQLlite on MAC, sqlitemeassqllite I. Introduction In mobile development, small databases are usually used for data management. SQLite is a very small and convenient

Mysql data backup and recovery, User Creation, authorization, mysql backup and recovery Mysql data backup and recovery, User Creation, authorization 1. Mysqldump> outfile. SQL 2. Mysql-uxxx-pxxx 3. Create user 'username' @ 'host' identified by '

MongoDB: gradually becoming irrelevant, and mongodb is irrelevantAbstract:Compared with TokuMX and PostgreSQL, MongoDB is at a disadvantage. However, it is still a good product and will continue to improve to compete with these alternative products.

Part 1 Operating System -------- LINUX 1. redhat linux server 7.2 Installation1. Use the first REDHAT installation disk to boot from the CDROM Installation Guide2. Use the default installation language ENGLISH and add Simplified Chinese as the

1. Install CDROM in Unixware 7.1.1) 1. boot from the CDROM Installation Boot Unixware CD-1CDROM must be a Slot1 or Slot2 Master)2. installation language. Select Proceed with installation in English and press enter to continue.3. Choose a zone for

1: Brief Introduction MongoDB is a distributed document database that supports a master-slave structure similar to a relational database. It stores documents in binary Json format, without locks, transactions, and indexes. 2: Installation

Where 1 = 1 & where 0 = 1 is often seen in SQL statements. After seeing it, I don't know what it means. I don't know the role of this statement, here I will give you one by one ...... Where 1 = 1; this condition is always True. In the case of an

What do you pay attention to when deleting data in a database? How to write code? Most of you can see these two problems. If you don't want to think about them, just use a Delete statement. Note that the deletion conditions should not be deleted.

1. select an appropriate Oracle optimizer There are three optimizer types in Oracle: A. RULE (based on Rules) B. COST (COST-based) C. CHOOSE (optional) Set the default optimizer. You can declare the OPTIMIZER_MODE parameter in the init. ora file, as

Related Articles: How to perform MySQL database table Fault Detection How to fix MySQL database tables How to lock MySQL database tables How to maintain MySQL Database Log Files Create a database table maintenance Specification It is a good idea to

SQLServer2005 and later versions provide a database image monitor, but the method for enabling it is quite special. With the graphic interface, the maintenance difficulty and cost of the SQLServer database image are greatly reduced. 1. First, open

Starting from version 8.2, DB2 users can specify a locking policy for each DB2 session. In previous versions, you can only configure an application by configuring the Database Configuration Parameter LOCKTIMEOUT. If you cannot obtain the lock, how

With the increasing popularity of information technology, the informatization of small and medium-sized enterprises is also in full swing! However, most SMEs encounter a lot of confusions when deploying IT systems: lack of professional technical