MySQL

Mysql master-slave installation configuration environment: the MySQL database version on the master-slave server is 5.1.34 Host IP Address: 192.168.0.1 slave IP Address: 192.168.0.2I. mySQL master server configuration 1. edit the configuration

Mysql adds a foreign key RESTRICT: as long as the table contains data directed to the master table, the relevant records cannot be deleted in the master table. In general, restrict is the safest option. Of course, it depends on the specific business.

Adjust the MYSQL checking rule gbk_bin to binary storage. gbk_chinese_ci is case-insensitive. server adjustment [mysqld] default-character-set = gbk # add this item to MySQL 5.5 -- default-character-set is removed in MySQL. default-collation =

MySQL Treat Tiny As Boolean Analysis Using MySqlClient to access the tinyint unsign field returns Boolean values true and false, but in fact the stored value of this field is 1-255 analysis: because there is no Boolean value in Mysql, mySqlClient is

Mysql knowledge expansion-database/table sharding MySQL Internet Oracle Enterprise Application Data Structure. database Replication can solve the access problem and cannot solve the large-scale concurrent writing problem. To solve this problem, we

The ultimate solution for Mysql garbled Code recently runs an SQL file in the Mysql database that comes with Linux. There is no problem in querying the database. You can see Chinese data, but in JSP page display but there is garbled, in spring

Scenario:An article table stores articles about PHP and MySQL, and you want to extract N records from each of these article categories.Test Table statement: CREATETABLEarticle (IdINTUNSIGNEDNOTNULLAUTO_INCREMENTPRIMARYKEY,CateVARCHAR (20

MySQL command line Export Database: 1, enter the bin folder under the MySQL Directory: cd MySQL to the bin folder directory, such as the command line I entered: cd C: \ Program Files \ MySQL Server 4.1 \ bin (or directly add the directory to the

Difference between SYSDATE () And NOW () in MySQL five functions in MySQL need to calculate the value of the current time: NOW. return time. Format: 2012-09-23 06: 48: 28 CURDATE. Date of the returned time. Format: 2012-09-23CURTIME. Format: 06: 48:

An ERROR 1452 ERROR occurred while adding Foreign keys to MySQL. Today, when I learned how to add Foreign keys to the database, I first created two tables orders and order_items. The storage engine is InnoDB, all of them have the orderid attribute

Mysql statement: set names UTF8 has always known only mysql_query ("set names UTF8"); it sets the database encoding, but it has never been clear what "set names UTF8" is. It is not until today that the set names... is a mysql statement. I really

Ubuntu mysql client emma Chinese garbled problem solution emma is installed with apt-get by default, emma does not support Chinese, the configuration file or directly modify the emma program source file (python ). Apt-get install emmasudo apt-get

The mysql function replaces the related subquery (Correlated subquery) SQL code CREATE TABLE '2017 _ teacher '('Teacher _ id' int (11) NOT NULL, 'School _ id' int (11) not null, primary key ('Teacher _ id'), KEY '2017 _ teacher_idx_school '('school _

The remote win connection of Ubuntu MySQL does not solve the problem of MySQL on Ubuntu10.04, and the root @ ubuntu :~ # Sudo apt-get install mysql after installing mysql-server www.2cto.com start mysql root @ ubuntu :~ #/Etc/init. d/mysql start can

MyISAM and InnoDB engine optimization 1. Public options www.2cto.com skip-external-locking // avoid MySQL external locks, reduce the chance of errors and enhance stability. Skip-name-resolve // disables MySQL from performing DNS resolution on

MYSQL 3: Full text search 1. Full text search www.2cto.com 1. MyISAM supports full text search, but InnoDB does not. 2. When using full text search, MySQL does not need to view each row separately, and does not need to analyze and process each word

Mysql high-speed import and export of large TXT textLet's talk about how to use loaddata for mysql to import TXT www.2cto.com. MySQL's load data infile statement is used to read rows from a text file and LOAD rows into a table at a high speed. The

After the MyISAM data table deletes the maximum number of records, the number cannot be reused. You can use the "AUTO_INCREMENT = n" option to specify an auto-increment initial value when creating a table. After the table is created, use the alter

How to modify the maximum number of mysql concurrent connections does not matter to MySQL. It mainly depends on the system and business logic. Method 1: Go to the MySQL installation directory and open the MYSQL configuration file my. ini or my. cnf

MySQL master-master replication, online table structure modification has always been to think that the dual-master architecture can solve the mysql table online DDL requirements, but there is no practical test experience. Later I found that there