MySQL

To add a field:ALTER TABLE ' User_movement_log 'Add column Gatewayid int not null default 0 after ' RegionID ' (which field is added later)The MySQL concat function can concatenate one or more strings, such asSelect Concat (' 10 ');Select Concat (' 1

Reprinted from Http://www.jb51.net/article/40179.htmFirst, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than

Use console to insert and query data to display garbled when using Navicat for MySQL to open a databaseProcessing process1. View the database encoded as "UTF8-UTF-8 Unicode", that is, the database character set is not a problem, the initial

Mysql-proxy Read/write separationMaster-slave replicationMySQL replication can distribute master's data across multiple slave, and then use slave to share the read pressure of master.Read/write separationMysql-proxy is a program between the MySQL

Note that you cannot omit any of the fields in the table. Include self-increment IDThe principle is "table interpolation table"INSERT intoprod_attrSelectA.* from ( SELECT 5 asprod_id,1

GRANT all privileges on * * to ' root ' @ '% ' with GRANT OPTION;FLUSH privileges;Use MySQLUpdate user set Password=password (' MySQL ') where user= ' root ';FLUSH privileges;Do it all on the master/slave Library--------------------------------------

The particularity of the Hash index structure, itsretrieval efficiency is very high, index retrieval can be located at once, unlike the B-tree index needs to be from the root node to the side point, and finally access to the page node so many IO

Next blog Address http://lee90.blog.51cto.com/10414478/1825478In the previous blog post, we used only one slave node.in the actual production environment, we must have multiple slave The node is responsible for reading the database. Let's say we

Installation process http://xiong51.blog.51cto.com/5239058/1826190Vim/etc/hosts192.168.0.30 MYSQL1192.168.0.31 MYSQL2Please note that MySQL installation must use the same disk, to avoid the next login inconsistent,Heartbeat do not enable service on

The so-called data type: A uniform classification of data. From the system point of view, is to use a unified approach to management, better use of limited space.There are three main categories of data types in sql: numeric type, String type, and

MySQL encoding causes the database to appear garbled in ChineseWorkaround:Modifying the MySQL database character encoding for Utf-8,utf-8 contains the characters that are required for all countries worldwide and is an international code.Specific

Article from collation: http://blog.jobbole.com/94606/Where amoeba for MySQL also implements read-write separationEnvironment Description:Operating system: CentOS6.5 32-bitPrimary server master:192.168.179.146From server

We know that session is a conversational technology that enables you to share data across scripts or to detect user status.How the session works (1) When a session is first enabled, a unique identifier is stored in a local cookie. (2) First, using

http://blog.itpub.net/28218939/viewspace-1975856/Concurrent Replication ( Parallel Replication ) Series three:MySQL 5.7 and MariaDB parallel replication ContrastMa Pengfei Technology MySQL database engineer After two mysql/mariadb on the

The official description of the three main APIs that PHP connects to the MySQL database server is as follows:http://php.net/manual/zh/mysqli.overview.phpPHP MySQL and mysqli transactionsIn PHP, MYSQLI has already encapsulated the operation of MySQL

There are many SQL syntax, which is a complete language. This only implements a function, does not do in-depth research.Target: Update the table regularly or clear the table.Case: A task that has been timed to empty the position information table.

1,JDK ConfigurationBecause the JDK website link does not directly support wget, you can download the JDK using the following method, where JDK version is jdk1.8.0_91:wget " Cookie:oraclelicense=accept-securebackup-cookie " http://download.oracle.com/

http://lobert.iteye.com/blog/1955841Get a table some days ago, nearly 4000w data, no index, primary key. (It's definitely a talent to build this watch.)This is a log table, recorded in the game the output and consumption of items, there was a

First, user management:1. New User: >create USER name identified by ' Ssapdrow '; 2. Change Password: >set PASSWORD for Name=password (' FDDDFD '); 3. Rights Management >show GRANTS for name; View name User Rights >

MySQL: A Summary of common basic SQL statements and a summary of mysqlsql statements SQL classification:DDL-Data Definition Language (CREATE, ALTER, DROP, DECLARE)DML-data manipulation language (SELECT, DELETE, UPDATE, INSERT)DCL-Data Control