MySQL

Alter Table' User_movement_log 'ADD columnGatewayidint not NULL default 0After ' RegionID ' (which field is added later)Alter TableX_connectionAdd' FEX-N752 'varchar(Ten)default NULL;//PRIMARY KeyAlter TableTabelnameAddnew_field_idint(5)

Implementation features: Upload Excel files and import them into the database according to the formatFind Phpecel on the internet but Phpexcel is too big, its own limited ability is not very good to streamline, finally found phpexcelreader this

First, the main advantagesThe concept of dual-machine hot standby simply say, is to maintain the status of two databases automatically synchronized.Operations on any one database are automatically applied to another database, keeping two of the

First, installation environmentoperating system:LinuxMysql version:mysql-5.6.24Second, the required softwareMysql-5.6.24.tar.gzthird, installation steps(1) Upload the installation packageMkdir/usr/setupupload mysql-5.6.24.tar.gz to /usr/setup(2)

The following is the entry level code, Master please service laughed at ~My myeclipse on spring the highest version is 3.* and hibernate the highest edition is 4.* in doing the project with the highest edition, so the code after debugging reported

Paging technology is very common in the development, I just went to the company to do two projects are used in the paging technology, so think about the paging technology in-depth exploration.There are several common paging methods:

1: Delete column ALTER TABLE "table name" DROP "column name" 2: Add column ALTER TABLE "table name" Add "column name" INT not NULL COMMENT ' comment description ' 3: Modify column type information "ALTER TABLE" table name Word "Change" column Name "

SameShowThe timestamp column is displayed in the same format as the datetime column. In other words, the display width is fixed at 19 characters, and the format is Yyyy-mm-dd HH:MM:SS.DifferentRangedatetime Retrieves and displays datetime values in

MySQL can use its own profile function to see what system resources are required to execute the statement, such as CPU, memory, disk IO, the default is the shutdown state to be manually opened, profile for the management or development of the DBA is

The 1 my.cnf configuration file is as follows:[Client]Port = 3306Socket =/data/3306/mysql.sock[MySQL]No-auto-rehash[Mysqld]user = MySQLPort = 3306Socket =/data/3306/mysql.sockBasedir =/application/mysqlDataDir =/data/3306/dataOpen_files_limit =

This article is to make a car parts of the e-commerce website, the general scenario is a list.php page, the page lists some parts and statistics of the total number for paging.Of course, the page can also specify the query criteria, such as the

Problem: MySQL statement using the% (percent semicolon) after like is not the more efficient the slower it runs!Total Time: 0.0489 sec 0.0691 0.0485 0.0467SELECT ' Goods_name ', ' goods_img ', ' sku_id ', ' import ' from ' goods ' WHERE ' goods_name

1, to the official web download MySQLis: Http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.21-winx64.zip2. Extract files to D-DriveOf course you can extract the other drive below, but note that it is best to place it under the root directory, which

20150510 Insert a random date add_time (int) in the table, 2014 random dates, preferably every monthDue to the time stamp format stored, one months difference 2678400, a day difference of 86400The function to useSELECT unix_timestamp (' 20141231 ') #

MySQL database recovery (using the mysqlbinlog command)MySQL database recovery (using the mysqlbinlog command) 1: Enable binlog LoggingModify the mysql configuration file mysql. ini and add it under the [mysqld] node.Copy the Code as follows: #

MYSQLVARCHAR sorting CAST, CONVERT function type conversion When creating a table on your own, you should create a field type as varchar (2). In fact, it should be set as integer (2). But today, we found a Sorting Problem in the background and a

MySQL id Association and index use case optimization, mysqlid The customer service MM call was received last night. A user reported that the database response was very slow. The mobile phone received an abnormal load alarm. After boarding the host,

Simple Analysis of the primary key function in MySQL, mysqlprimary In 5.1.46, the optimizer made some changes to the choice of the primary key: Performance: While looking for the shortest index for a covering index scan, the optimizer did not

Analysis of slave monitoring latency in MySQL, mysqlslave In the MySQL replication environment, we usually judge the SLAVE latency only based on the value of Seconds_Behind_Master. This is acceptable in most cases, but not accurate enough. More

Four Methods for killing MySQL connections in batches and four methods for mysql Method 1Use the connection information in the information_schema.processlist table to generate a temporary MySQL connection statement file to be processed, and then