type of table

Recently, in the ASP forum to see a lot of netizens asked how to get the database table name, field name and how to delete the field, add the operation so write this article. I am more familiar with SQL Server, so SQL Server is the column: SET

Database statement: DDL (data definition language) ALTER create drop DML (data manipulation language) inset Delete update DTL (Data transaction language) Conmmit rollback savepoint Select

According to experience, MySQL table data generally reach millions, query efficiency will be very low, easy to cause table lock, or even accumulate a lot of connections, directly hang off; the level of the table can be very much less than these

The server operating system I use is Ubuntu 12.04 64-bit LTS with 512M memory and no virtual memory enabled. After optimization, server memory generally occupies between 256m-378m, and stable operation. So, I should like to share my configuration

In fact, for many people have forgotten a lot of SQL statements, or do not understand a lot, because there is a database graphics operation software, convenient for everyone, but we can not forget the most fundamental things, especially some of the

1. What do you think is the most important process in the project?The analysis, design phase to find the priority of progress2. If you are given a team of 4-6 people, how to assign?Pick a skilled person as my substitute. The other person distributes

The earlier use of Lua, just a small part of the project, suddenly arose to write some articles about Lua, to record the points that have been learned.I'm using LUA5.2 as a case here.Lua as a lightweight scripting language has been widely used in

The earlier use of Lua, just a small part of the project, suddenly arose to write some articles about Lua, to record the points that have been learned.I'm using LUA5.2 as a case here.Lua as a lightweight scripting language has been widely used in

First look at the classification of SQL statements supported by MySQL 1, database selection, creation, discard and change Use Create Database Drap Database ALTER DATABASE 2, data table and index creation, change and discard CREATE table drop

Previously introduced a small MySQL backup php script program, but it is not for MySQL shell permissions of the virtual host users, here want to talk about more common backup and restore methods, suitable for their own host friends. 1, about Backup:

This section describes a special stored procedure, that is, a trigger. First, the concept of triggers A trigger is a special type of stored procedure that differs from the stored procedure we described earlier. Triggers are executed primarily by

MyISAM type does not support advanced processing such as transaction processing, and InnoDB type support, this article for you to explain the difference between Engine=innodb and Engine=myisam in MySQL, do not understand the friends can learn, I

Full-Text Search can retrieve varchar,text,image fields, but a table can only build one Full-text indexSQL Server 2000 introduces the ability to perform full-text searches on these types of data stored in the image column.If there is no Full-text

According to the literal meaning is to write the parameters of the whole. This is not supported in a later version. Many of the information on the Internet is directly using Myisam_recover can be used to achieve the MySQL database table repair, but

First of all, some uses of MySQL's distinct keywords: 1. This can be used when count does not duplicate records, such as SELECT COUNT (DISTINCT ID) from tablename , or how many records with different IDs in the Talbebname table are counted. 2, you

When you first build a database with MySQL administrator, the table defaults to the InnoDB type, and you don't care. Later, when using Access2mysql to guide the data found can only lead to myisam type of table, do not know what the difference

a table function can accept a query statement or a cursor as an input parameter and can output multiple rows of data. The function can be executed in parallel, and the data stream can be continuously output, known as pipeline output. The table

Turn from: http://bbs.chinaunix.net/thread-3685716-1-1.html Recently, the realization principle of the Timer quartz cluster is studied, and a method of using database lock to realize concurrency control in cluster environment is found. Because the

Sysbench is a modular, cross-platform, multithreaded benchmarking tool that is used to assess the load of databases under various system parameters. For more information on this project, please see: http://sysbench.sourceforge.net. It mainly

When using MySQL, if you find that transactions can not be rolled back, but hibernate, Spring, JDBC and other configurations are not obvious problems, do not worry, first look at the table MySQL created there is no problem, that is the type of table.