Database Administrator

Oracle Data Pump content = data_only Next, let's look at a test to verify that the data can be restored only after being exported. Even if the table structure has changed, it can restore the corresponding columns, 1) SQL> desc liuwenhe.

Problems caused by an Oracle row-Level Lock Found the problem: Today, the development colleagues asked to modify several fields of a row of data, which is very simple, because the Oracle lock mechanism is not properly understood. I connected to

SQLServer: how to search for %, _, [, sqlserver There are two methods: 1. Use ESCAPE to define ESCAPE characters"%" And""And" [] "are considered as wildcards when they appear separately. In order to check whether there are percent signs (%),

85th questions, 05385 85. You executed the following command to drop a user:Drop user scott CASCADE;Which two statements regarding the above command are correct? (Choose two .)A. All the objects of scott are moved to the Recycle Bin.B. Any objects

Character garbled during MySQL migration in Windows, mysql garbled We often copy a copy of the MySQL Data DIRECTORY directly to the new environment. Normally, we can restart MySQL to use it, but sometimes we will encounter some problems: 1. when

Redis implements the sender, and redis implements the sender The auto increment auto-increment id value of mysql may leak some sensitive data. For example, if the user_id of the User table is auto-incrementing, the id value displayed in the url

Mysql uses DATE_FORMAT to recover erroneous data. Because of the new development project, when colleagues create data, the time format is "20150708", but the expected data format is ".The database uses mysql, and the time field type is varchar (10)

SQL server is installed by default, how to create a new user and password, SQL server 1. Adapt to window identity Login2. Create a queryCreate login logs 1 with password = '000000'Create user bai2 for login lifecycle 13. Right-click the attribute

MySQL Optimization-securely shut down MySQL instances and optimized mysql instances Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46812371Closing Process: 1. initiate shutdown and send a SIGTERM Signal 2.

About Oracle 10g schedule job, oracleschedule -- Job permission Grant create job to somebody;-- Job creationBeginDbms_scheduler.create_job (Job_name => 'agent _ LIQUIDATION_JOB ',Job_type => 'stored _ PROCEDURE ',Job_action => 'agent _ LIQUIDATION.

Enable MySQL query cache and MySQL Cache Enabling MySQL query cache can greatly reduce the CPU usage of the database server. The actual usage is: the CPU usage before enabling is about 120%, which is reduced to 10%. View the query cache status:

Example of myloader restoring mysql database and myloadermysql Mydumper is a lightweight third-party open-source tool for mysql database backup. The backup mode is logical backup. It supports multithreading, And the backup speed is much higher than

Use Python's MySQLdb module in Win7, win7mysqldbOverview: In Linux, the processing of this part is good, but it is a little troublesome on Windows. The trouble is not in the installation process, but may cause some problems during the installation

Install mysql on centos7 and centos7mysql From centos7, to maintain a better open source, the default database of the minimal version of the system is changed to mariadb, I decided to install mysql (after all, there is a difference between the two

Oracle queries whether the Department (326) of a person belongs to the Department string (329 | 2) or the sub-department of the Department string, 326329   Department 326 is the parent department of Department 329, and Department 2 and department 326

Configure remote connection to mysql database Connect to remote mysql database, mysqlconnect There is a local machine, and the IP address is localip remote machine. The IP address remoteip must connect to the mysql database of the remote machine

Galera source code installation, galera source code --- 1. install the main component on which galera depends # echo "192.168.1.25 db00 db00.mysql.com">/etc/hostsyum-y install cmake gcc-c ++ autoconf automake zlib * libxml * \ ncurses-devel libtool

C # Fourth job: MySQL database and C # operate MySQL database, 1. Basic MySQL database operations include the following two tasks: (1) Insert data from two files into the MySQL database (Note: when creating a database, select gb2312 -- GB2312

MongoDB installation and introduction In the previous sections, we introduced the web development of nodejs. For now, we will talk about databases. The databases we usually use are mysql and mongodb. Today we will talk about mongodb. MongoDB is a

Dbrd 8.4.6 source code compilation and installation, dbrd8.4.6 source code compilation ---------------------------- 0. system Environment -------------------------- db01 192.168.50.10/dev/sdb1 master node db02 192.168.50.20/dev/sdb1 slave node #