MySQL

View partition status SELECT * from information_schema. Partitions WHERE table_name=' table_name '; Partition_name: Name of the partitionPartition_method: Type of partitionTable_rows: Number of partitioned data barsRange Partition:

In order to prevent unscrupulous site crawler crawling articles, hereby identified, reproduced please indicate the source of the article. LAPLACEDEMON/SJQ.Http://www.cnblogs.com/shijiaqi1066/p/3857808.htmlStorage Engine OverviewThe storage engine is

Environment: Windows 8.1+mysql 5.6.19The first thing to say is that under Windows MySQL My.ini location is: drive letter \programdata\mysql\mysql Server 5.6, that is, under the data path, if the system disk, ProgramData folder is hidden Non-system

TriggerScene:Log system, record what to do with student tables!The problem solved:1, to get each student record is modified the time, in order to issue the record log action!2, to perform a certain operation, you need to get the current record of

Share a MySQL custom function instance of the CREATE function.Mysql> delimiter $$mysql> CREATE FUNCTION myFunction(in_string VARCHAR (255),In_find_str VARCHAR (20),In_repl_str VARCHAR (20))-RETURNS VARCHAR (255)BEGINDECLARE l_new_string VARCHAR (255)

Let's take a look at the ZABBIX database structure:1. Groups table650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/43/5E/wKioL1PZ9l2DeGFfAAEDMjzH7lI086.jpg "title=" 1.png " alt= "Wkiol1pz9l2degffaaedmjzh7li086.jpg"/>Group ID can be found

with ROLLUP in MySQLThere is a very interesting application with ROLLUP in MySQL's extended SQL, which is based on the statistical data of the group and then the same statistic (Sum,avg,count ... ), very similar to the functionality of statistical

——————————————————————————————————————————————————————————First, start and exit1. Go to MySQL: start MySQL Command line Client (MySQL dos interface) and enter the installation password directly. At this point the prompt is:mysql>2. Exit

MySQL Replication Introduction:MySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers.The MySQL master server writes the update to the binary log file

In order to prevent unscrupulous site crawler crawling articles, hereby identified, reproduced please indicate the source of the article. LAPLACEDEMON/SJQ.Http://www.cnblogs.com/shijiaqi1066/p/3858050.html1 transactions (Transaction) Overview 1.1

INSERT into table (a,b,c) VALUES (All-in-all) on DUPLICATE KEY UPDATE c=c+1;INSERT in the use of the DUPLICATE KEY updateIf the on DUPLICATE KEY update is specified and the row is inserted causing duplicate values to occur in a unique index or

Change InnoDB data page size optimization MySQLhttp://www.mysqlsupport.cn/change_innodb_page_size/Change InnoDB data page size optimization MySQL2009 December 13 posted by WUBX Wu Bingxi Source: http://www.mysqlsupport.cn/Contact: wubingxi#gmail.com

First, preface since MySQL5.1.6, has added a very distinctive feature – event scheduler, which can be used to perform certain tasks on a timed basis (for example: Deleting records, summarizing data, etc.). To replace work that was previously only

TIMESTAMP the default value for the setting is Current_timestampTIMESTAMP settings automatically update as the table changes is on update current_timestampBut becauseThere can be at most one field set in a table Current_timestampIt is not possible

#coding: UTF8 ########## #firefly, MySQL and memcached common use ########### From Firefly.dbentrust.dbpool import Dbpool From firefly.dbentrust.memclient import mclient From Firefly.dbentrust.mmode import madmin hostname =

A trigger is a special kind of stored procedure that triggers a run when inserting, deleting, or altering data in a particular table, which has finer and more complex data control than the standard functionality of the database itself.Database

In order to keep pace with the times, work idle began to study Python, just a touch on the python this "elegant" syntax to attract! Later, Django, although not much in-depth research, but the new concept of web development is very interested in,

Analysis of MYSQL REPEATABLE-READ isolation level, repeatableread The REPEATABLE-READ can be read repeatedly, and the contents of the select table in the set autocommit = 0 or start transaction state will not change. This isolation level may cause

Export mysql Data to excel and related computing, and export mysql Data After mysql queries the data, you can select to export the file as a csv file by default. If the data type is integer, you can add multiple values in CONCAT ('\ '', filed) to

Mysql DATA group obtains all the largest record rows of a field value, mysql Field Requirements: The same uid (User) in the table has multiple game level records. Now we need to retrieve the data of the highest level of all users, and the earlier