The partitioned view allows you to split the data in a large table into smaller member tables. According to a range of data values, the data to be partitioned between the member tables. The range of data for each member of the table are defined in a CHECK constraint specified for partitioning column. Then define a view that […]

Oracle’s SQL * Loader can load external data into a database table. Here is the SQL * Loader’s basic characteristics: 1) can be loaded into the data of the different types of data files and data files 2) can be loaded into a fixed format, freely given community as well as the degree of long format […]

1. Database table structure (Access):  The userid: Text (user ID) to save the uploaded file  On FileContentType: Text (used to save the uploaded file type, eg: “Application / msword”, used primarily to keep users can download this file correctly)  FileContent: OLE Object (save the file data)  2. HTML file  muploadfile.htm  <Form Name=”upload_file” enctype=”multipart/form-data” action=”muploadfile.asp” method=post>  <input type=hidden name=”UserID” value=”abc”>  the <input type=hidden name=”FileUploadStart”> ‘is used to indicate the start file […]

If you encounter a particularly large table in ORACLE, you can use the partition table to change the performance of their applications. If you encounter a particularly large table in ORACLE, you can use the partition table to change the performance of their applications. A company’s annual sales have a tremendous record, DBA recommendations to the company quarterly data on a […]

MySQL officially released version 5.5.8 With msi installation package to win the next Ubuntu is still a conservative version 5.1 rpm and tar.gz source version on the official website, has yet to ubuntu installation source, I do not rpm too cold, we can only compile the source code is installed, refer to the online compiler […]

Object Type:  AF = the polymerization function (CLR)  C = CHECK constraint  D = DEFAULT (constraint or stand-alone)  F = FOREIGN KEY constraint  PK = PRIMARY KEY constraint  P = SQL stored procedures  PC = assembly (CLR) stored procedure  Fn = SQL scalar function  FS = assembly (CLR) scalar function  FT = assembly (CLR) table-valued […]

The sysobjects table created for each object in the database (constraint, default, log, rule, stored procedures, etc.) in the table per line. Only in tempdb, each temporary object one row in the table. Column name Data type Description name sysname object name. Id int object identification number. xtype char (2) object type. Can be in one of […]

The data storage server Game data is broadly divided into static configuration data and dynamic players. Here focuses on the player data storage solutions. Although the game application write operations than read operations, but added the cache layer is still necessary. Another problem is that multiple application servers start to read data from the database in an […]

Forgot your MySQL password problem With MySQL, we may often forget the MySQL password, this time, you can think of, what does? Reluctantly reload?Unwise, we can use the following methods to solve the problem of your MySQL password. (1) Open / etc / mysql directory under the debian.cnf file, find the [client] user name and password […]

[Original] solutions for IP operation in the database Suitable for display output IP by IP range query. A SQL statement to the database the IP format characters in the form of an integer stored interchangeable IP, based on the four bytes of storage, maximum FF.FF.FF.FF bit dotted decimal to 255.255.255.255. We can understand that this is an […]