MySQL

1. Call the MySQL formatted decimal function format (x,d)For example:[HTML]View PlainCopy Select Format (23456.789,2); [HTML]View PlainCopy Select Formate (salary,2); Output:[HTML]View PlainCopy

Python 3 MySQL Library operations one, basic related knowledgeMySQL database basic Operation knowledge ReserveDatabase server: One computer (high memory requirements)Database management system: Like MySQL, is a softwareDatabase: Oldboy_stu,

Source installation MySQLYum Install Ncurses-devel Libaio-devel-ymkdir/server/tools-pcd/server/toolswget https://cmake.org/files/v2.8/ Cmake-2.8.8.tar.gztar XF cmake-2.8.8.tar.gzcd cmake-2.8.8./configuregmake gmake Installwhich cmake/usr/local/bin/

The old version of MySQL in Linux modifies the database encoding method isModify MY.CNFVi/etc/my.cnf in [Client] under Add DEFAULT-CHARACTER-SET=UTF8 Under [mysqld] add Default-character-set=utf8 If this is changed in the new version, it will

Summary:This article is for reference to other people's articles (http://blog.csdn.net/voidccc/article/details/40077329)1 Various tree-shaped structuresOriginally not intended to start from the two-fork search tree, because there are too many

1.order by optimizationImplementation method:1. According to the index field sorting, the data extracted from the index is already well sequenced and returned directly to the client;2. The index is not used, and the fetched data is returned to the

Deploy MySQL high-availability cluster (mysql-mmm+ master-Slave synchronization)4 Database servers:Four databases retain initial four libraries, all other libraries deletedHost 158Host 137Host 99Host 67Host 102 (with four other pings

1. Numbers: Integral type: tinyinit int bigintThe Tinyinit int bigint, respectively, refers to the different number widths, from the smallest to the largestThere are also int (5) in parentheses after the number, for the deposit is not any

CharSet Modify CharSet engine character set modify the character set engines # # Operations folder (library) code as follows: SHOW CREATE database db_name; add CREATE Database DB1 CharSet UTF8; check show databases;show CREATE database DB1; change

First, the MySQL database stored procedures:1. What is a stored procedureThe stored procedure (English: Stored Procedure) is a set of SQL statements written in a large database system to complete a particular function. The stored procedure is

First, introduce the type of indexMySQL Common indexes are: Primary key index, unique index, normal index, full-text index, composite indexPRIMARY key (primary key index) ALTER TABLE ' table_name ' Add PRIMARY KEY (' column ') unique (unique index)

Access URL: http://dev.mysql.com/downloads/repo/apt/http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/The first step , download Mysql-apt-config_0.8.0-1_all.deb,Visit URL http://dev.mysql.com/downloads/repo/apt/Step Two ,Step three , enter the

1. MySQL uses the command line to start the Times wrong "system error 5 occurred", as follows:Cause: The CMD program is not running as an administratorSolution: Locate the command Prompt in the Start menu, right-click to select Run as Administrator2,

1.1.1.Related Conceptsby default, MySQL uses asynchronous replication, that is, the transaction execution on master and the copy operation on the slave do not need to be synchronized,master You do not have to wait for The replication thread on

Install MySQL on two machines, synchronize the contents of two databases with SYRNCConfigure the primary  Add Server-id = 1log-bin=mysql-bin (generate binary log) in config file vi/etc/my.cnf above these two are the two optional

MySQL does not support arrays. However, sometimes it is necessary to combine several tables of data, in the stored procedure, after the more complex operation obtained the results of direct output to the caller, such as the number of tables matching

1. Download MySQL Community Server 5.7.13Unzip the MySQL archive package2. Modify My-default.iniskip-grant-tables function is to install MySQL password-free login, and then you can change the root password.3. Add Environment variablesThe operation

Reference Source: http://www.cnblogs.com/zhyunfe/p/6209074.html1. Select the most applicable field propertiesMySQL is good at supporting large data volumes, but in general, the smaller the tables in the database, the faster queries are executed on

Zabbix monitoring MySQL1.1 Client Configuration 1.1.1 Install client PackageYum--IVH zabbix-agent-3.0. 3-1. el6.x86_64.rpm1.1.2 Editing a configuration file/etc/zabbix/zabbix_agentd.d/userparameter_mysql.confuserparameter=mysql.version,mysql-

Mysql modification to enable remote connection, mysql modification to enable Regarding the remote connection to mysql, we often encounter mysql databases stored on a certain computer during our work. If you want to connect to the mysql service, the