MySQL binary log is often said to be the Bin-log, is the MySQL implementation of the changes produced by the binary logging file, its main role is two:* Data reply* Master-slave database. For the slave side to perform additions and deletions to
Colloquial business : refers to a set of operations that are either executed successfully or not executed .----> atomicity Other sessions are not able to see the process of intermediate changes until all operations have been completed--
http://zhangzhaoaaa.iteye.com/blog/1689412 reference: "MySQL Technology insider SQL Programming"SELECT DISTINCT From lefttablejoin On WhereGroup Bywith{cube| ROLLUP}HavingOrder byLimitProcessing order
From
On
Join
where
GROUP BY
Overview:In Centos 6.5, the installation of MySQL via Yum is version 5.1, older, so you want to install the high version of 5.6.20 via source code.Body:One: Uninstall the old versionUse the following command to check if MySQL Server is
http://www.jzxue.com/shujuku/mysql/201109/06-8742.html MySQL The syntax for establishing foreign KEY constraints is too obscure to understand, and has to write down notes.1. Create a foreign key when building a tableCREATE TABLE table_s ( ' id '
Installation
Server installation. Use command: sudo yum-y install Mysql-server
Client Installation. Use command: sudo yum-y install MySQL
Set boot up
Sudo/sbin/chkconfig--add mysqld
Sudo/sbin/chkconfig
Full-text indexing has been supported since MySQL 4.0, but the default minimum index length for MySQL is 4. If the English default value is reasonable, but the majority of Chinese words are 2 characters, which results in less than 4 words can not be
MySQL compiles the installation from the 5.5 release CMake, not the previous make, so install the CMake and install all of the development pack groups properly:1. Prepare the installation environment first:#cmake:
1. Modify the character encoding and modify it all to GBK. like ' %char% ' ; set character_set_database=GBK;Among them, Character_set_client is the client-side encoding method, Character_set_connection is used for establishing the connection
about the stored procedures under MySQL and the creation of events The following is the main function of the stored procedure is to query the table half a year ago data, if there is a file, and then delete the data. CREATE definer = ' root ' @ '
Web development under Mac, MySQL is a must-have program.1. How do I install MySQL?Brew Install MySQL2. How do I start MySQL?Mysqld &mysql.server start3. How to enable MySQL to boot fromMkdir-p ~/library/--prefix mysql '/*. plist
The first position of a string is labeled 1
ASCII (STR): Returns the ASCII code value of the leftmost character
CONV (N, From_base, to_base): Converts a number between different cardinality, returns a string number of number N, or null
The SQL language is divided into three levels.1, the DDL statement, the data definition statement, defines the database, the table, the index and so on the object definition. Common statements include: Create, DROP, alter. 2, DML statements, data
Start learning from a simple landing page.Premise: There is already a static website of Html+css+jsLogin:PHP connects to the database and reads the data.1PHP2 $username=Root;3 $userpass=Shao;4 $dbhost=localhost;5 $dbdatabase=mytest;6 7 //first
MySQL has 5 levels of permissions, namely:Clobal level,database level,table level,column level,routine level.1,clobal level: It is the global permission for the entire MySQL database server. Permissions to a database in MySQL, or to a table in a
First, define a stored procedure in MySQL: Delimiter//create procedure proc () begin SELECT * from users;end//then, in PHP,//declares a storage space used to store procedure execution return data , the space size 131072 is 128Kdefine
Rotten mud: the basic commands used by the mysql database.
This article was sponsored by Xiuyi linfeng and first launched in the dark world.
1Format of connecting to the database
Mysql-h IP-u user name-p password;
1.1Connect to a remote database
MySQL database startup and Shutdown
MySQL database server usually refers to mysqld, while command line mysql is a mysql client program. These two concepts are often confusing. Generally, the mysql server is started to start the mysqld process.
Mysql user permission assignment and master-slave synchronous ReplicationGrant wgdp user query permission: grant select on wg_dp. * to 'wgdp '@' % 'identified by 'weigou123'; grant all privileges on *. * to 'yangshao' @ '%' identified by 'weigou123'
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service