Database Administrator

UPDATE SMS_PROVINCE set provincename = REPLACE (PROVINCENAME, CHAR (10), ''), CHAR (13 ),''); Environment: RHEL5 + MySQL Solution: UPDATE tablename SET field = REPLACE (field, CHAR (10), "), CHAR (13 ),"); Char (10): line feed Char (13): Carriage

Due to work requirements, we need to synchronize all the data in the Business Database to another processing server today. While working on the solution, I thought a lot of ways. Of course, the fastest way is to use physical hot backup. However, I

Crs_stop-all Crs_stop-all When crs_stop-all is executed in RAC, the system prompts that some services cannot be stopped. When crs_stat-t is used to check the status, the state of the services that cannot be stopped is UNKNOWN,The service cannot

The following error is reported when the standby uard standby database starts a recover:ORA-16014: log 4 sequence #1 not archived, no available destinations Solution:First lookSQL> show parameter db_recovery NAME TYPE VALUE---------------------------

Hibernate provides many methods for object operations. This article briefly introduces the use and comparison of these methods. Before describing the methods, describe the three states of objects in hibernate: transient, persistent,

When hql is used in Hibernate for query, list or Iterator is usually used to obtain the query results. Here we will briefly describe the differences between the two methods and applicable scenarios. List: The queried results will be fully stored in

I. background The production environment IBM P560 is currently used on the standby machine of Oracle universal uard. When oracle applies archive logs, check the server I/O and find that the I/O on Hdisk0 and 1 can sometimes reach 100%. There are

When you access a table, an error similar to the following occurs:ORA-01578: Oracle data block upted (file #6, block #344)ORA-01110: data file 6: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ TEST. DBF'The reason is that the data file contains

MapReduce can be used in MongoDB for complex aggregate queries. Map and Reduce functions can be implemented using JavaScript. You can use db. runCommand or mapReduce command to execute a MapReduce operation: Db. runCommand (

First, the experiment environmentTwo Linux servers with MySQL installed can be YUM installed, Binary packages installed, or source code packages compiled. Then, the master-slave synchronization of the two MySQL servers is realized, how to Implement

The MySQL innodb Storage engine uses the same row lock mechanism as Oracle. The following experiment shows how to view the row locks in the system. The following is the test process:Session 1: update records Mysql> set autocommit = off; Query OK, 0

Result: a stored procedure is written under a user in a database. During the stored procedure, DBLINK is used to connect to another database and the number of users in this database is obtained, insert a table in the current database. 2. steps: 1.

This time, we will separately investigate the time of Master/Slave latency. The master-slave latency mentioned here does not refer to the "Slave database update performance cannot keep up with the master database", but to the "Delay Time for a

I. Error code: ORA-12547Symptoms:(1) Oracle listening and Service Startup are normal and no error is reported(2) Check the log without any exception information(3) The local commands on the server can connect to oracle and execute query commands.(4)

Find something to do. After this project was completed, I found that on-site testers generally did not grasp the SQL statements at the front-end (that is, they clicked the operations on the front-end interface and then went to the database to find

1. DESCRIBE command The usage is as follows: SQL> describe nchar_tst (nchar_tst indicates the table name) The result is as follows: Is the name empty? Type-----------------------------------------------------------------------------Name nchar

table detection, creation, and deletion. # Include # Include # Include # Include # Include BoolDb_tableExists (sqlite3 * db,Const Char* Tbname) { IntNRet; Const Char* SzTail; Sqlite3_stmt * pvm; CharSQL [1024]; Sprintf

Multi-row function Aggregation FunctionExecution sequence:TName -- where -- group by -- having -- order by (select) The alias in the current clause cannot appear in the where clause, nor can the aggregate (Group) function be used. When clustering

The amount of data in a table in the database is large at work, which is a log table. Under normal circumstances, there will be no query operation, but if there is not much data in the table sharding, it takes several minutes to execute a simple SQL

In general, the foreign key of the Oracle sub-table needs to be indexed, If no index is added to the foreign key, modifying the parent table will lock the child table. 1. Update the primary key of the parent table, and the child table will be