MySQL

Database server, database, and table relationships – the so-called database server is installed on the machine with a database management program that manages multiple databases, and the general developer creates a database for each application.　　–

One: MySQL LockTwo: MySQL TransactionsThree: MySQL Isolation Level1.1 Why do you have a lock? Because the database wants to solve concurrency control problems. At the same time, there may be multiple clients manipulating a table's data or some data,

MySQL is a very popular small-scale relational database management system. MySQL is now widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source,

1. Unsigned is the unsigned number type.The type range of int is -2147483648~2147483647, and the type range of int unsigned is 0~4294967295Unsigned can also have negative effects, such as:CREATE TABLE T (a int unsigned,b int unsigned)INSERT into T

1, in MySQL, the reserved word can not be used as table name, field name, etc., as follows:Mysql> ALTER TABLE student ADD column desc varchar (+) after name;1064-you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server

View Log Data/xxx.errFound the following error[ERROR] innodb:attempted to open a previously opened tablespace. Previous tablespace Mysql/innodb_index_stats uses space id:2 at filepath:. \mysql\innodb_index_stats.ibd. Cannot open tablespace

1.MySQL Multi-Instance Introduction 1.1. What is MySQL multi-instanceMySQL multi-instance is on a machine to open a number of different service ports (such as: 3306,3307), running multiple MySQL service process, through different sockets to listen

One, prepare the tool.Httpd-2.4.12-win32-vc9.zipPhp-5.4.40-win32-vc9-x86.zipPhpmyadmin-4.2.13.2-all-languagesmysql-5.6.23-winx64 Configuration Reference: http://blog.csdn.net/q98842674/article/details/12094777Second, the environment to build.1,

MySQL multi-instance is to install the MySQL database software on one server, configure different listening ports, the application can connect different databases according to the port, the library and the library do not affect each other.1.

Realize:Yum installs the appropriate libraries because I have to install nginx,php on this machine, so the following libraries are installed# yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel 

Reference: http://blog.csdn.net/dbaxiaosa/article/details/22421969Master configuration:[Mysqld]Datadir=/var/lib/mysqlSocket=/var/lib/mysql/mysql.sockUser=mysql# Disabling Symbolic-links is recommended to prevent assorted security risksSymbolic-links=

Connecting the remote database with Navicat the wrong times:1130 is This MySQL ServerThe reason is that the database account is not authorized for this IP, so remote logins cannot be performed.Workaround:Log on to the database server,[Email

Briefly:The method of analyzing the performance of MySQL statement query in addition to using the EXPLAIN output execution plan, you can also let the MySQL record query over a specified time of the statement, we will exceed the specified time of the

data type 1, Signed number calculation principle such as tinyint accounted for 1 bytes or 8 bits:-2 of 7 square =-128~2 7 -1=127tinyint of 1 bytes unsigned value range 0~255, signed number range -128~127smallint accounted for 2 bytes unsigned number

Like what:UPDATE Test.tb_vobile ASet a.name = ' 111 'WHEREa.ID = (select Max (ID) ID from test.tb_vobile)Error:[SQL] UPDATE Test.tb_vobile ASet a.name = ' 111 'WHEREa.ID = (select Max (ID) ID from test.tb_vobile)[ERR] 1093-you can ' t specify target

This demo mysql-5.5.28-linux2.6-x86_64.tar.gz (a little bit to mysql.tar.gzInstallation under Ubuntu:1. Download the MySQL installation package to/usr/local/, unzip the TAR-XVF mysql...tar.gz (Mobile instruction MV) 2, add a shortcut to MySQL:ln-s

MySQL active/standby hot standby and mysql active/standby 1. Slave_IO_Running: No mysql> show slave status\G*************************** 1. row *************************** Slave_IO_State: Master_Host: 192.16.10.21

Use codeblocks to debug mysqlCodeblocks debugging mysql environment setup 1.decompress mysql-5.6.23.zip to the user root directory ~ /2. In the user root directory ~ /, Create a Folder build and mysql3. open codeblocks, create an empty project,

MySQL Show command and mysqlshow command We can use the show command to view the MySQL status and variables and find the System Bottleneck: Mysql> show status display status information (Extended show status like 'xxx ') Mysql> show variables

Use mysql on Mac 1. Install mysql 2. Start the mysql service in preference settings 3. Open the terminal and enter mysql. chenhong:~ chenhong$ mysql-bash: mysql: command not found 4. Set the mysql command and enter 1) alias mysql