article details

ORIGINAL http://blog.csdn.net/yoyo_yaya/article/details/1494944 These days have been trying to do a project with the Oracle database into a database with msSql2000, I thought as long as the database connection pool to change to change on it, did not

This used to solve install mysql from source, usually run configure, make & & make install command may encounter problems and solutions One problem, an error is as follows: configure: error: in `/Application/mysql-5.1.58': configure: error: no acc

Emp table in the scott user. Scott is a practice account user, the password is tiger, if you do not have this account You can always set up, practice is over you can always delete. Strokes of both, the play of both to go. 10g version of the database,

Turn: http://blog.csdn.net/5iasp/article/details/4268090 package com.aspboy.base.cache; / * * Created on 2004-8-18 * * "Least recently used algorithm" (LRU algorithm), it is the most recent period has been visited at least eliminated the line. *

From: http://blog.csdn.net/flyingbox/article/details/623189 Operators can achieve by connecting multiple table query. Connections are the main features of the relational database model, is it different from other types of database management system,

From the reference Art of a simple design freelance programmerのtrivial: http://blog.csdn.net/dl88250/article/details/2084489 Many people tend to fall into when using a SQL error, that is too focused on the results is correct, and ignore the different

Transfer http://blog.csdn.net/simonezhlx/article/details/3167343 I do not know who the original author of the original, is very regrettable. Thanks original and reproduced by, so that more people learn useful knowledge. A nested table definition: Nes

http://blog.csdn.net/basenet855x/article/details/6826731 JDBC provides a database batch processing capabilities, large quantities of data operations (add, delete, etc.) in the case can significantly improve system performance. I had contact with a pr

Original Address: http://blog.csdn.net/chenqqabcdchenqqabcd/article/details/6726673 N must use the string "" double quotes, from test contains the single quote '' If, by contrast, can not properly determine whether the property is equal to the s

1 Problem Description Given a positive integer n, to output a length n array, the array elements are random numbers, ranging from 0 - n-1, and the elements can not be repeated. For example when n = 3, need to obtain an array of length 3, the element

Originally from http://blog.csdn.net/xiexl/article/details/6747767 ; In Web applications, sometimes need to follow a fixed template to export data to Word, such as the approval process alone, in the process after processing is complete the process in

Some packages are. Src.rpm at the end, these packages contain the source code is the rpm package to be compiled during installation. Installation of these packages, there are two ways: Method One: 1. Execute rpm-i your-package.src.rpm 2. Cd / usr / s

Reproduced http://blog.csdn.net/xw13106209/article/details/6583357 Navicat Premium is a multi-connected database management tool that allows you to simultaneously connect to a single program MySQL, SQLite, Oracle, and PostgreSQL database, so that dif

Transfer http://blog.csdn.net/zdl1016/article/details/6116752 Detailed netstat Common Options -N show ip address and port directly, the port will not resolve or resolves: Resolution 80 for the www, 22 for the ssh, 13 for the daytime The IP resolves t

Accelerate page loading speed has a way to CSS and JS files into another separate server, so access to the larger context than the main server can share the pressure, if your site uses some mainstream Ajax library such as JQuery or Prototype, you can

1, <> 2, separate >,<,( sometimes used, sometimes not) 3, like "% _" percent sign in the former. 4, no analysis of the table. 5, a separate reference to the first position of non-composite index in the index column. 6 character field

http://blog.csdn.net/htl258/article/details/4006668 SQL Server 2005 introduced several new sorting (ranking) function, such as ROW_NUMBER, RANK, DENSE_RANK and so on. These new functions enable you to effectively analyze data and to sort the query re

Transfer: http://blog.csdn.net/steves/article/details/5212983 Subqueries: Nested query in the other query. (Also known as the inner query) Main query: a query that contains other child as the main query. (Also known as the outer query) Subquery is di

Turn http://blog.csdn.net/iinel/article/details/4321383 HTTP Core Module supports a number of built-in variable, variable name and apache In correspondence, such as $http_user_agent,$http_cookie HTTP request information such that the variable . More

Transfer: http://blog.csdn.net/Phoenix_99/article/details/5825926 Today, a simple sum in PL / SQL cursor (cursor / Cursor) usage. I believe many do development or maintenance of the DBA looking for work, met a similar surface as the question: Please

Transfer: http://blog.csdn.net/lenovouser/article/details/5142314 nocatalog way is to use the control file as the catalog, each time a backup control file which must be written to a lot of backup information, which more and more control file backup i

Tokyocabinet project team uses a database, a key-value of the DBM database is now quite hot under the concept of nosql a database to record and share the feeling of use. Links Details: http://www.162cm.com/p/tokyotyrant.html Project official website:

Oracle parameters and parameters of the viewing method of classification Original address: http://blog.csdn.net/tianlesoftware/article/details/5583655 Oracle database system in the initialization parameter file init.ora to set the parameters to confi

select * from (select * from emp e where e.sal < 1000 order by e.empno) t order by t.sal desc; This SQL query containing a sub-sub-query can be performed while this SQL Quote select * from emp where dept in (Select dept from valid_deps where dept_hea

1, after construction of the table add primary key ALTER way ALTER TABLE Table name WITH NOCHECK ADD CONSTRAINT [PK_ Table name ] PRIMARY KEY NONCLUSTERED ( [ Field name 1], [ Field name 2] ) This code requires the original table design, this field d

Transfer: http://blog.csdn.net/ylqmf/article/details/5368903 First, the primary key and clustered index is not a one to one match Under normal circumstances we believe that the clustered index and primary key are matched, as long as you SQLServer tab

Transfer: http://blog.csdn.net/lenotang/article/details/3329501 What is indexing Chinese dictionary to get the directory page (index) analogy: just as the dictionary of Chinese characters as stored by the page, SQL Server data record is stored by the

Carried out recently in centos database replication, we found this error, you can not create a function (function) can copy database tables, stored procedures, functions alone here, never in the online search to solve this problem: mysql appear Error

Today in http://blog.csdn.net/ningjieshuijing/article/details/6530687 inadvertently found two small interval of time to keyword: numtodsinterval, numtoyminterval, interval. Feel the future might use, so the reproduced over. The following is a brief i

zz http://blog.csdn.net/tianlesoftware/article/details/4915223 First, what is the Oracle character set Oracle byte character set is a collection of the data interpretation of symbols, size of the points, are mutually inclusive relationship. ORACLE su

http://blog.csdn.net/tianlesoftware/article/details/5827245 http://blog.csdn.net/tianlesoftware/article/details/5826546 If you want to analyze the SQL performance on a particular issue, usually we have to look at the SQL execution plan to see each st