Mongodb Study Notes 01 and mongodb Study NotesMongodb Overview Mongodb is a document-type NoSQL database that stores bson-> json binary. The internal execution engine is a js interpreter that stores documents into a bson structure and converts them
SQLServer -- How to completely copy a database, sqlserver Database For the sake of conciseness, the source database is referred to as S, and the target database is called T. SqlDelta is required in this article. Click to open the link. 1.
ORA-01591: Lock pending Distributed Transaction Processing Solution, ora-01591 Transaction Processing On-site report has a function can not go on, background log error: java. SQL. SQLException: ORA-01591: Lock is pending Distributed Transaction
Use JDBC to connect to the MySQL database-Typical Case Analysis (9)-financial account DAO design and implementation, jdbcmysql Reprinted Please note:Http://blog.csdn.net/uniquewonderq Problem: 1. Add a financial account: 2. Modify the information
[Mysql5.6] after the master and slave ip addresses are changed, the synchronization is re-established. mysql5.6ip In this case:Master/Slave System centos6.5 mysql5.6 Because the IP address of the IDC has changed, the original active data cannot
Redis sentinel cluster construction and Jedis test graphic tutorial , redisjedis In Redis, the establishment of sentinel clusters and the Jedis test graphic tutorial  have already written the setup and testing of sentinel clusters in Redis.
A problem that requires attention when the keywords in the Multi-Table connection query are incorrect. Author: iamlaosong In multi-table join queries, the most common thing is inner join, and the most commonly used in inner join is equivalent join.
A small problem with the auto-scaling feature of Oracle 11g partitions, oracle11g It is very convenient to use the automatic partition Extension function in Oracle 11g, but it also brings about a problem, that is, after the export and import, the
The method for creating a sequence in Mysql. Create table emp_seq (seq VARCHAR (8); insert into emp_seq VALUES ('0'); UPDATE emp_seq SET seq = LAST_INSERT_ID (seq + 1); SELECT LAST_INSERT_ID (); This is exactly the same as the sequence of
Use MySQL in Linux -- forget the root password and modify the default MySQL encoding, mysqlroot Overview: This blog will not explain or explain MySQL syntax any more. If you want to know or be familiar with MySQL, Please study it on your own Baidu
TNS-03505 name cannot be resolved, tns-03505 name resolved TNS-03505 name can not resolve the problem Phenomenon: [oracle@db01 admin]$ tnsping priTNS Ping Utility for Linux: Version 18.104.22.168.0 - Production on 15-JUN-2015 21:57:52Copyright (c) 1997, 2
EBS concurrency manager table CMCLEAN. SQL, ebs concurrent cmclean. SQL Concurrent Processing-CMCLEAN. SQL-Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1] Modification
Data cleansing Note: sorts strings to dates (A Date Field is processed in multiple formats ), Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have
Summary of oracle ebs architecture and management basics (12.1.3), ebs12.1.3 Document directory Blog of Sunan Sheng 1. Overall architecture 2 1.1 directory structure 2 1.2 layer-3 logical architecture 3 2. Basic management 5 2.1 start
Execl data import SQL Server, execl data import SQL You can import execl table data to the database to specify columns or *Note:This statement can only be executed in the local database. If the remote server is connected, the statement should be
Oracle hierarchical query learning summary, oracle levelHierarchical query document directory: 1.1 Summary 21.2 node terminology 21.3 use the connect by and start with clauses 31.4 hierarchical query instance 31.5 query from bottom up 41.6 Delete
Redis translation memory optimization and redis Translation Memory OptimizationSpecial encoding of small aggregate data types Special encoding small set data type Since Redis 2.2 bytes data types are optimized to use less space up to a certain size.
Oracle instance Performance Analysis and Optimization-AWR learning summary, oracleawrSummary Sunan Health Blog's article ORACLE performance optimization includes instance performance optimization and SQL statement performance optimization. They
SQL statements Delete duplicate records and retain only one record. Copy codeThe Code is as follows:Delete WeiBoTopics where Id in (select max (Id) from WeiBoTopics group by WeiBoId, Title having COUNT (*)> 1 ); SQL: delete duplicate data. Only one
50 SQL Query Techniques, query statement examples, 50 SQL statements Student (S #, Sname, Sage, Ssex) Student tableCourse (C #, Cname, T #) CurriculumSC (S #, C #, score) Orders tableTeacher (T #, Tname) Instructor table Problem:1. query the student