MySQL

1. Download: current MySQL version to 5.6.20Http://dev.mysql.com/downloads/mysql ChooseSource Code 2. Necessary PackagesYum-y Install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* Make CMake 3

MySQL is an open source database, below to say some of my understanding, then he mainly with what operation, called SQL (Structure query languages) statement, Structured query statements, I have never known when the operation of the time to add

Suppose there is a Student score table (CJ) as followsName Subject ResultsZhang San Language 80Zhang San Mathematics 90Zhang San Physics 85John Doe Language 85John Doe Mathematics 92John Doe Physics 82Harry Mathematics 60Want to becomeName Language

Default PHP installation, only the common default modules are installed, some are not commonly used or less, there is no default installCan be increased by the following methods, as follows to increase pdo-mysql as an examplewget 

after the MySQL database is officially online, open the binlog log and discover that the disk is exploding 100G. Roots in my.cnf inside binlogMysql>show variables like '%log% ';check the relevant settings for this parameter:|expire_logs_days |0|This

The Mysql query run process is broadly divided into 4 stages:Grammar analysis (sql_parse.cc)>>sql_resolver.cc # Join.prepareGenerate logical Query plan (sql_optimizer.cc)>># join.optimizeGenerate physical query plan (sql_planner.cc)Run the explain

Note:Sql> Source F:weibo.sql (execute related SQL file)Sql> SELECT * from Sina to outfile "/weibo.txt" (export the corresponding data to C: weibo.txt)1. MySQL 5.0 after its client only support GBK, it can be in sql> set names GBK;For example:set

1.1.1. ERROR 1418"Environment description"mysql5.0.67"Problem description"Error 1418 error encountered while creating stored procedure.# SQL statement to create a functionCREATE FUNCTION ' xxx ' (num01 int) Returnsint (11)Begindeclare mm int default

This is the second time to install MySQL, the first installation took a few hours to understand the installation of each page, this light looking for the installation package to find a few, so it feels necessary to do a full installation note. (a

1. Examples of stored procedures: DELIMITER $$DROP PROCEDURE IF EXISTS helloworld$$CREATE PROCEDURE HelloWorld ()BEGINSelect "Hello world!";end$$DELIMITER; 2. Variable declaration Use declare to declare, default

MySQL garbled problem:What happens: When you use the command line to view database data, the Chinese language is displayed as garbled.Error when inserting Chinese data with command line.Solution Ideas:1, enter at the command line: [Show variables

Group_concat () Main function: The same line can be combined togetherThe complete syntax is as follows:Group_concat ([DISTINCT] field to connect [order by Asc/desc sort field] [Separator ' delimiter '])Basic QuerySQL code SELECT * from AA;

Group_concat () is a function provided by the MySQL database, usually in conjunction with group by, depending on the official MySQL text block: http://dev.mysql.com/doc/refman/5.0/en/

db.optThe main function of the file is to record information such as the default character set and Word Fu She of the current database. If you want to modify the character set of a database, directly edit the database corresponding to theoptfiles,

The following two ways must all be setCharacter Set:latin1Collation:latin1_swedish_ciDisplay Encoding Method:Show Character SetThank you, Su Yong, I rubbed his class, heheDisplay first, then set. Recommended Utf-8 (see attachment) Show

1. insert a new recordinto the table using the INSERT statement, with the following syntax: INSERT into table name [( field List )] values(Value list). 2. Update the operation and character set using the SET statement, for example

A lock is a mechanism by which a computer coordinates multiple processes or threads concurrently accessing a resource . In a database, data is a resource shared by many users in addition to contention for traditional computing resources such as CPU,

Solution to saving mysql delete data space usage Today, the Space Provider told me that the database space is full. After checking, I found that the user behavior record data table on the website actually occupied more than 20 MB. After six months

Comparison with MSSQL to learn about MYSQL (7) -- Query and mssqlmysql Compares the similarities and differences between people to deepen the memory The same is true for this article, which compares with MSSQL to learn MYSQL (7). The same content is

Remote connection to mysql: [1130, mysql: 1130] The following error is returned when you remotely connect to mysql: 1130 -host 'localhost' is not allowed to connect to this mysql server Solution Log on to mysql with the root account locally,