Database Administrator

Http://www.infoq.com/cn/news/2014/01/neo4j-2 Recently, Neo Technology released Neo4j 2.0 GA with a brand new graph browser, node label, an optional mode, and improved Cypher. The most noteworthy improvement of Neo4j 2.0 is the brand new browser UI,

After twists and turns, we finally successfully configured Oracle11GR2 ASM when the vmwarevm Redhat Enterprise Linux 6 has installed a single-node Oracle database 11G R2. The record process is as follows: Environment: VMWare Player 5.0.2 build-103176

Paip. Improve Stability --- automatic detection of sleep mysql database dead connections and killAuthor Attilax airlong, EMAIL: 1466519819@qq.comSource: attilax ColumnAddress: http://blog.csdn.net/attilax///// Detects the leakage of the application

1. -- case sensitiveSelect * from a where a = 'abcde' collate Chinese_PRC_CS_AI -- case sensitiveSelect * from a where a = 'abcde' collate Chinese_PRC_CI_AI -- case insensitive2. If you want to make all the storage tables on the server case

Maybe the first time I came into contact with select... into... from... and insert... select... many people may misunderstand that, on the surface, it is not that simple to query relevant information and add it to a table. Next, pig will introduce

The components involved in Redis are based on the C language. Each C file corresponds to a module and can be considered as a component. Based on the analysis of its source code, we can conclude that the following components and modules and methods

The storage outline can be used to fix the SQL Execution Plan. The storage outline consists of a series of optimizer hints related to SQL statements. When the storage outline is available, oracle automatically generates an execution plan for the

1. Add FieldsAlter table student add age number (5 );2. Modify FieldsAlter table student modify age number (10 );Alter table table2 rename column result to result2;3. delete a fieldAlter table student drop column age;4. Clear table dataTruncate

I. DescriptionThe oracle exp/imp command is used to export/import databases; Data export: Exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp -- export database fully exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp full

For example, if you insert 1 million data records to a databaseSqlite3_exec (db, "insert into name values 'lxkxf', '24';", 0, 0, & zErrMsg );It will repeatedly Open and Close database files for 1 million times, so the speed will of course be slow.

1. ADO. NET Provider For SQLite.ADO. NET provider is provided by a company in Hong Kong (looks like). For the project address, see: http://sourceforge.net/projects/sqlite-dotnet22. encapsulate SQLite. NET and provide a simple operation help

If you want to install PostgreSQL for a project, the installation file of .exe is downloaded to run. At the beginning, it was very smooth. I know that the installation was complete and there was a damn dialog box during database initialization

In a (poor)PostgreSQLOnly a small modification is required in the query.(ANY (ARRAY [...]) to ANY (VALUES (...)))The query time can be reduced from 20 s to 0.2 s. From the simplest learning and useEXPLAIN ANALYZEStart from learning to useS

1. Relationship between original documents and entitiesIt can be a one-to-one, one-to-many, and many-to-many relationship. In general, they are a one-to-one relationship: an original document corresponds to only one entity. In special circumstances,

Table 1: Table 2:Id info id value1 a 1 102 B 2 303 c4 dWant to getId value1 10 // Table 2 exists2 20 // Table 2 exists3 0 // Table 2 does not exist4 0 // Table 2 does not existWhether an SQL statement can be used to solve the problem, instead of

Bosses:I have a query SQL statement. I hope to use an SQL statement to obtain the result. The problem is as follows:Table X:A B C D------------------Beijing Guangzhou 1000 10Beijing, Shenzhen 1200 20Beijing Shanghai 500 30Beijing, Tianjin, 300,

For example, the following...1. For the Date FieldAccess: #1981-28-12 #SQLSERVER2000: '2017-02-12'2. Differences in SQL statements: select and update are similar in operations on a single table,However, the difference between the update statement

For example, I have some news information, including these fields: News ID, news Name, news ShortIntro, news Detail, news PublishTime. Now I want to store it in the database, and then retrieve it from the database and put it in the GridView for

Today, a buddy sent a request for help, saying that the master node was never synchronized. He sent an error message to the master node and found that the error message from the error log was not truncated to show slave status \ G ), however, when

This article introduces how to monitor mysql with fixed port 3306. I. Client 1. Add it to/usr/loca/zabbix/conf/zabbix_agentd.conf. UserParameter=mysql_3306[*],mysql -h localhost –P 3306 -uzabbix -pzabbix -e "show global status"|grep "\"|cut –f2 If