MySQL

Mysql:http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/ YumRepolist enabled |grepMySQLRM-rf/etc/Yum. repos.d/mysql*.config-file-path Vim/etc/Yum. repos.d/mysql-Community.repo #note The BaseURL, CENTOS6--EL6, view the system version:uname-R #

MysqlBackup and RecoveryBackup Hot Spares , which is the direct backup to the database running, has no effect on the running database; Cold , which means to copy the relevant data physical files when the database is stopped (shut down);

Monyog This web-side MySQL monitoring software is very useful.Specifically, not to everyone Amway.Direct paste Baidu Network disk: https://qdcu01.baidupcs.com/file/419603905dcca568ce6ad4c5927b0d2b?bkt=p2-nj-922&fid= 4094912105-250528-1004876217482528

In general, it is through master-slave replication (Master-slave) to synchronize the data, and then through the read-write separation (mysql-proxy) to improve the database's concurrency load of such a scenario to deploy and implement.First of all, I'

Computer environmentWIN10 64-bit Enterprise Edition1. Unzip the zip file to a certain path.2. My-default.ini renamed under Copy directory (My.ini)3. Open My.ini[MYSQLD] Add the followingCharacter-set-server=utf8Other changes to the configuration as

When you create a foreign key in MySQL, you often fail because there are a lot of details in MySQL that we need to keep in mind, and the following are some common reasons why I have summarized and consulted the data myself.1. The type or size of the

--First insert the data in the user table as followsTRUNCATE TABLE UserInfo;INSERT into ' userinfo ' (' ID ', ' UserName ', ' userlogin ', ' userpassword ', ' useremail ', ' usertype ')VALUES (1, ' Zhang San ', ' Zhangsan ', ' Zhangsan ', ' [email

Although there is a connection query in MySQL to implement a multi-table connection query, but the performance of the connection query is poor, so there is a subquery.1, in theory, the subquery can appear anywhere in the query statement, but the

MySQL configuration file[Mysqld] ... Log-error= "D:/phpstudy/log/mysql/mysql_log_err.txt" log= "D:/phpstudy/log/mysql/mysql_log.txt" long_ Query_time =2 log-slow-queries= "D:/phpstudy/log/mysql/mysql_log_slow.txt" ...Open mysql

Under Window1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p

1. Add the column and declare the default value directly when you create the table, as follows:CREATE TABLE ' table1 ' ( int(notNULL ,timestamp NULL default Current_timestamp ) ENGINE=DEFAULT CHARSET=UTF8;If you are working under Navicat, the type

1, description of stored procedures and functions:* Stored procedures and functions are a collection of SQL statements that have been compiled and stored in the database in advance.* The difference between stored procedures and functions:The &

1. Slave the above IO line thread attached the Master, and requests the log content from the specified location (or from the beginning of the log) to the designated log file;2. When Master receives a request from an IO thread from Slave, the IO

Both on delete and on update have restrict,no Action, cascade,set null property. Now explain the meaning of their attributes separately.On DELETERestrict (constraint): When the corresponding record is deleted in the parent table (that is, the source

> Not garbled thinking process(1) Linux#修改linux系统字符集# vi/etc/sysconfig/i18nLang= "ZH_CN. UTF-8 "(2) Mysql#临时设置字符集 (Method i)mysql> set names UTF8;#临时设置字符集 (Method Two)# mysql-uroot-p--default-character-set=utf8#永久设置字符集# VI/ETC/MY.CNF[Client] {Client,

> Not garbled thinking process(1) Linux#修改linux系统字符集# vi/etc/sysconfig/i18nLang= "ZH_CN. UTF-8 "(2) Mysql#临时设置字符集 (Method i)mysql> set names UTF8;#临时设置字符集 (Method Two)# mysql-uroot-p--default-character-set=utf8#永久设置字符集# VI/ETC/MY.CNF[Client] {Client,

Sometimes the database machine is not the same machine as the project, then it involves the remote link database, the steps to configure the remote connection database are as follows:1. View the information in the user table in MySQL database, for

Getting started with SQL (4): Creating and modifying data tables This chapter describes how to use scripts to create databases, how to use scripts to create tables, and how to delete and modify objects. CREATE statement: CREATE Basic syntax for

Installation tutorial of mysql5.7.12 in Linux, linuxmysql5.7.12 Install MySQL on LinuxEnvironment: Windows 7Virtual Machine: Oracle VMVirtualBoxUbuntukylin-14.04.1-amd64.iso: LinuxMysql: 5.7.12 I. Prepare the environmentStep 1:Install Virtual

Nodejs remote link to mysql database summary, nodejsmysql Nodejs linked to the remote mysql, which took a long morning to complete. I thought it was okay to use it directly, but I couldn't find it. I finally found a method after reading various