MySQL

In the Guide database, engaged in one hours have a watch to not go in, holding not to pour in.I got a look at the stuff.When importing MySQL data, if you encounter the right syntax to using the Btree syntax error, do not panicBecause the new version

Background:Novice Operation Misoperation, delete my entire test list (test, no backup)Operation Command:mysql> Update test set name= ' Tom ';The resulting result:All the name columns of the test table become

Compiling PHP:./configure--prefix=/usr/local/php--with-config-file-path=/usr/local/php/etc--enable-fpm--with-fpm-user= PHP-FPM--with-fpm-group=php-fpm--with-mysql-dir=/usr/local/mysql--with-mysql-sock=/tmp/mysql.sock-- With-libxml-dir--with-gd--with-

Commands for backing up librariesMysqldump-uroot-pwangshaojun discuz >/data/discuz.sqlSpecify user password, redirect to a fileRecoveryMysql-uroot-pwangshaojun Discuz You can also back up a tableMysqldump-uroot-pwangshaojun discuz pre_forum_post

The problem was found in the work a few days ago: When a field is of type varchar, the field holds values similar to ' 100,200,300 ' and ' 100 ' or ' 100,400 '. When you write a SQL statement, you make such a mistake, such as:Select Id,provinceid

Such as:SELECT * from Table_1 left joins table_2 on table_1.id = table_2.t1_id and table_2.status > 0SELECT * from table_1 LEFT join table_2 on table_1.id = table_2.t1_id where table_2.status > 0Two queries were found to be different.Why there is a

MySQL master-slave replication-------------------------------------------------------------Environment:Two servers (two instances of a single server)Main Library: (IP 192.168.1.1 port:3306)from library: (IP 192.168.1.2 port:3306)Authorized

1 DROP TABLE IF EXISTS' tb1 ';2 CREATE TABLE' tb1 ' (3' ID 'int( One) not NULLAuto_increment,4' A 'varchar(255)DEFAULT NULL,5' B 'varchar(255)DEFAULT NULL,6' Content 'varchar(255)DEFAULT NULL,7 PRIMARY KEY(' id ')8 ) 9 -- -------------------------

Yesterday I wrote a blog post about MySQL's Loose index scan (http://www.cnblogs.com/wingsless/p/5037625.html), Later I found that the main purpose of the optimization method mentioned last time was to achieve loose index scan, and on the execution

1 Source of the problemIn the AC Group a buddy asks for error 1146 (42S02): Table ' xxx ' doesn ' t exist this error2 Specific problem analysisThis table belongs to InnoDB space because IBDATA1 records the meta-data of the InnoDB table, which is

1.properties configuration filedriver=com.mysql.jdbc.driver#urlurl=jdbc:mysql://Localhost:3306/pabitel# Useruser=Root#passwordpassword=4936566962. Build a class to get the connection1 Public classDBHelper {2 PrivateDBHelper () {}3 Private

MySQL-based Dynamic string processingIn MySQL, we often see some processing of dynamic strings, such as DYNAMIC_STRING. In order to record the actual length of the dynamic string, the maximum length of the buffer, and the new memory allocated and

MySQL composite PartitionIn the end, it is still open-source software. MySQL's support for composite partitions is far from that of Oracle. In MySQL 5.6, only the RANGE and LIST subpartitions are supported, and the subpartitions can only be HASH and

MySQL common UPDATE operationsOverview test environment: mysql 5.6.21 step CREATE test table create table 'product' ('proid' int (11) not null AUTO_INCREMENT COMMENT 'item TABLE Primary key', 'price' decimal) not null comment 'item price', 'type'

[Mysql] pessimistic lock, mysqlMysql locks In a concurrent environment, Dirty Read, Unrepeatable Read, Phantom Read, and Lost update may occur, therefore, mysql introduces many lock concepts. MySQL InnoDB locks data rows in four types: Shared locks (

Basic statement for mysql addition, deletion, modification, and query, and mysql addition, deletion, and modificationAdd: Insert Insert into Table Name (Field 1, Field 2, Field 3 ...... Field N) values (value 1, value 2, value 3 ); If you do not

MySQL for Group By optimization, mysql for Group Yesterday I wrote a blog post on MySQL's loose index scan (http://www.cnblogs.com/wingsless/p/5037625.html), and later I found that the main purpose of the optimization method mentioned last time was

MySQL Nested-Loop Join algorithm LearningAfter playing MySQL for more than two years, I found that many people say that MySQL is inferior to Oracle in terms of optimizer. In fact, to some extent, it is true, however, after all, MySQL is only

How to optimize MySQL insert performance and mysqlinsert For systems with large data volumes, the query efficiency is low, and the insertion time is long. We have a business system. It takes 4-5 minutes to import data every day. This time-consuming

Mysql tips and tips 1. Format datetime Fields SELECT DATE_FORMAT (date, '% Y-% m-% d % h: % m: % s') date FROM message; Result: + --------------------- +| Date |+ --------------------- +| 02:12:35 || 02:12:55 || 02:12:00 || 02:12:20 || 03:12