MySQL

Project Environment:VIP 192.168.122.100MYSQL1 192.168.122.10MYSQL2 192.168.122.20First, MySQL master sync (do not use shared storage, data saving local storage)1. MYSQL1 192.168.122.10:[Email protected] ~]# VIM/ETC/MY.CNFLog-bin=mysql-binServer-id =

A: New two sheetsStudent tableCREATE TABLE Student (Idint PRIMARY KEY auto_increment,Snamevarchar () Not NULL);SELECT * from student;INSERT into student VALUES (1, ' Zhang San '), (2, ' John Doe '), (3, ' Harry ');Course TableCREATE TABLE Course

A friend asked: MySQL paging seems to have been a problem, what is the optimization method? Online to see the online recommended some pagination method, but it seems not very feasible, can you review it?　　Method 1: Directly use SQL statements

#!/usr/bin/env python#coding:utf-8import mysqldbtry:         #连接mysql的方法: Connect (' IP ', ' user ', ' password ', ' dbname ')          #conn = MySQLdb.connect (host= ' localhost ', user= ' root ', passwd= ' 123456 ', db= ' test ')     conn =

1. Forget the root passwordedit the MySQL master profile my.cnf the [mysqld] field to add the parameter skip-grant, restart the database service, so that you can enter the database without authorization mysql-uroot, modify the corresponding user

Linux Operational Phase IV (IV) MySQL User and Rights Management1. Related concepts:"mysql User:similar VSFTPD virtual users;password, its own unique encryption mechanism, PASSWORD function;user name @ host;User name within the characters, host

First, the table name should not be mixed with case (that is, camel), you should use an underscore as a connector.Because in thinkphp, the M (' Table name ') method, the case of this form of table name will automatically be converted into an

First, installation methodThere are two main ways to install MySQL: one is to compile and install through the source code, which is suitable for advanced users to customize the MySQL feature, and the other is to install it using the compiled

1, set timer: terminal-typed: crontab-e command2, then write to * * * */home/db_bak_file/dbbak.sh >>/home/db_bak_file/backdbinfo. This statement works by executing the script under/home/db_bak_file/dbbak.sh at 23 o ' Day, and keeping the log in

Extract:Book: MySQL performance Tuning and architecture designA series:(Sort by order)optimization of cache parameters for MySQL database performance optimizationHttp://isky000.com/database/mysql-perfornamce-tuning-cache-parameterTable structure

We know that MySQL was in the past, the storage engine was MyISAM by default ,but as the requirements for transactions and concurrency increased, the InnoDB engine was introduced. It has a range of features that support transactional security.

Overview:In CentOS 6.4, the installation of MySQL via Yum is version 5.1, older, so you want to install the high version of 5.6.14 via source code.Text: One: Uninstall the old versionUse the following command to check if MySQL Server is installedRpm-

MySQL terminal operationLog in to MySQLMysql-uroot-plary123Create a databaseCreate DATABASE TestShow all databasesShow databasesEnter a databaseUse DatabaseNameShow all tables in the current databaseShow tablesCreate a tableCREATE TABLE ' T_article '

MySQL terminal operationLog in to MySQLMysql-uroot-plary123Create a databaseCreate DATABASE TestShow all databasesShow databasesEnter a databaseUse DatabaseNameShow all tables in the current databaseShow tablesCreate a tableCREATE TABLE ' T_article '

Yesterday, when I was finishing something, I saw an article collected a few years ago, and today I write two words.It's about the "table" prefix that appears when the watch is exploded, and then Hex (), then Unhex () the real table name.The code is

The character set is a set of symbols and encoding rules, whether in the Oracle database or in the MySQL database, there is a character set selection problem, and if in the database creation phase does not select the correct character set, you may

1. SQL data storage by condition普通的 INSERT INTO 插入：INSERT INTO card(cardno, cardnum) VALUES(‘1111‘, ‘100‘);INSERT INTO card(cardno, cardnum) VALUES(‘2222‘, ‘200‘);Inserting a condition into SQLinsert INTO Card (Cardno, Cardnum) select ' 111 ' ,

1. Create a calculated field:Concat, select Concat (Vend_name, ' (', Vend_country, ') ') from vendors;Rtrim, remove the right spaceSelect A+b as C from table order by C;2. Data processing functions:Text processing functions: Upper Ex:select Upper (a)

The three mysql-related functions are:The now () function returns the current datetime with ' Yyyy-mm-dd HH:MM:SS ' and can be stored directly in the DateTime field.Curdate () returns today's date in the format ' Yyyy-mm-dd ', which can be stored

The following transfers are from:http://www.tech-q.cn/archiver/tid-11673.htmlMost of the time, we created an index in MySQL, but some queries are still slow, and no index is used at all! In general, some fields may not have been indexed, or the