MySQL

Using the external health foreign keyForeign key (current table field name) References table name (field name in Table name) on UPDATE cascade on DELETE Cascade Engine=innodb;Foreign Health The current table refers to another table name. Synchronize

Main 1:192.168.246.130Main 2:192.168.246.131Master 1 Compounding: my.conf server_id= the Log-Bin=Mysql-bin Binlog-Format=Mixed Relay-Log=Mysql-Relay Master 2 compounding: my.conf server_id=131 Log-Bin=Mysql-bin Binlog-Format=Mixed

See a realityThere is a bank account formCREATE TABLE Account(ID int primary KEY,Balance float);Now there is a PHP program , to complete the 1 yuan, go to 2 Number on the accountPHP $mysqli=NewMysqli ("localhost","Root","hsp123","Test");

In real-world applications, most companies will typically compile and install MySQL:http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.22.tar.gz/System environment: CentOS 6.7 Finall1, install the required dependency packageYum Install-y ncurses-

Integrated WAMP Environment command not works, change password in phpMyAdminPermissions--root user modification, executionthen you'll find that you can't log in with phpMyAdmin.Modify the phpMyAdmin inside the corresponding password can be

Today I am from 7 o'clock in the evening to the next day now, in order to solve a MySQL coding problem, the problem is described, the received Chinese parameters in the Java class sysout is normal, but in the execution of SQL all become the??? , I

1, change the table method may be your account is not allowed to login from the remote, only in localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost"

1), install MySQL on the two machines separately, keepalived2),Keepalived Master-Slave:Master: vim/etc/keepalived/keepalived.confVrrp_instance Vi_1 {State backup # Backup with BackupInterface Eth2 #用的是哪个网卡virtual_router_id #虚拟路由地址必须一样 to be

The learning of SET statements:practice of defining User variables using Selectchange the following statement to the form of select:Set @VAR = (select sum (amount) from penalties);My Changes:Select @VAR: = (select sum (amount) from penalties);I can

To export the Mysqldump tool to use with MySQL, the basic usage is:Shell> mysqldump [OPTIONS] database [tables]If you do not give any tables, the entire database will be exported.By executing mysqldump--help, you can get a list of options supported

MySQL master-Slave synchronization configurationIntroduction: Test environmentMultiple instances of a single MySQLHost IP Address 10.0.0.52Master 3306Salve 3307First, the main library to open the Binlog service1.1 Modifying the configuration file 330

Information on the regional level is stored in the Jsjh_district table.To update the District_level region information for the Jsjh_goods_district tableDELIMITER $$DROP PROCEDURE IF EXISTSUpdate_district_level $$CREATE PROCEDUREUpdate_district_level

the Select command represents the currently selected (connected) database. SELECT command format:mysql> Select Database ();The Select command in MySQL is similar to print or write in other programming languages, and you can use it to display the

Edit MySQL master configuration file my.cnf# VIM/ETC/MY.CNF Add a parameter under the [Mysqld] fieldSkip-grantRestart Database Services service mysqld restart4) modify the corresponding user password> Use MySQL;> Update user Set Password=password ('

1. Create a new userLogin mysql@>mysql-u root-p@> Password//create user mysql> insert into Mysql.user (Host,user,password) VALUES ("localhost", " Phplamp ", Password (" 1234 "));//Refresh the System permissions table Mysql>flush privileges; This

1. find information for all students[Sql]select * FROM studentRows affected : 0Time : 0.000s2. Identify all the people who have passed the test[Sql]select * from student where Studentno in (select Studentno from result where Studentresult > 60)Rows

Indexing is the key to fast searching. MySQL indexing is important for the efficient operation of MySQL. Here are a few common types of MySQL indexes.In a database table, indexing a field can greatly improve query speed. Suppose we create a mytable

Mysql I/O memory optimization and mysqlio Memory Optimization Mysql Ver 14.14 Distrib 5.6.19, for Linux (i686) using EditLine wrapper I. mysql directory files Ibdata1: The system tablespace contains data dictionaries, rollback logs, and

MySQL service cannot be started on Windows (7) (on a local computer) Error 1067: Unexpected Process Termination, mysql1067 During this time, many people complained about why their MySQL could not be opened. I have come up with several solutions to

MySQL supports row-level locks, table-level locks, and page-level locks. In computer science, a lock is a synchronization mechanism used to forcibly restrict resource access when multiple threads are executed, that is, to ensure that mutex