MySQL

one, CONCAT () functionThe CONCAT () function is used to concatenate multiple strings into a single string. Using data table info as an example, where select Id,name from Info LIMIT 1, the return result is +----+--------+| ID |  Name |+----+--------+

1. To view log log, modify the configuration file My.ini and modify it under [mysqld]:2. After the modification, restart the MySQL service to take effect;3. The Error_log,slow_log log timestamp defaults to UTC after the default installation,

A transaction did not commit to the B transaction is equal to not do get the previous dataBut the query in a transaction is the data after the operation.Data that is not submitted is only visible to itself and is not being update to the

1. Download MySQL Community Server 5.6.132. Unzip the MySQL archive packageUnzip the downloaded MySQL package into a custom directory, and my unzip directory is:"D:\Program Files\mysql\mysql-5.6.13-win32"Will unzip the directory under the default

Latch locks and tlock (transaction locks), DML lock rules, and deadlock analysis in MySQL.I. The relationship between latch and TlockLatch: Designed to protect the correctness of critical resources, such as protecting the memory pages that are being

First, Origin:As soon as I got to work today, I heard that Error-log recorded a lot ofERROR 1820 (HY000): Must reset your password using ALTER USER statement before executing this statement.　　Second, the MySQL user password expires processing:1,

In the previous chapter, the method of transmitting values between HTML and PHP is described in this chapter, which will be used by MySQL in Wamp for the next chapter of PHP call data preparation. Again, the author's wamp version is 3.0.6 64bitTo

Summary: Data recovery is a very important task that the DBA does not do much, but I have to understandBackground: Data mis-operation can be broadly divided into two categories1 DML operations (such as non-conditional update deletions)2 DDL

1Copy the F:\phptools\php5.5\php.ini-production and rename it to php.ini;2Add F:\phptools\php5.5 and F:\phptools\php5.5\ext to the environment variable path, select Computer, right-click Properties--Advanced system settings--environment

A MySQL 5.7 partition table performance degradation Case Analysis Original: http://www.talkwithtrend.com/Article/216803 prefaceIt is hoped that this article will enable MySQL5.7.18 users to know the traps existing in the use of partitioned tables

Install the dependency package first to avoid problems during the installation process[[email protected] liuzhen]# yum-y install gcc gcc-c++[[email protected] liuzhen]# yum-y install Cmake[[email protected] liuzhen]# yum-y install

DirectoryPreface: What is JDBCI. Preparatory work (i): MySQL installation configuration and basic LearningIi. preparatory Work (ii): Download the jar package for the database and import itThird, JDBC Basic operation(1) Define the class of the record

An introductionTopics in this sectionMulti-Table Connection queryCompound conditional Join QuerySub-queryPrepare tableCompany.employeeCompany.department#Build TableCREATE TABLE Department (ID int,name varchar (20) ; CREATE table employee (ID int

There are 5 functions in MySQL that need to calculate the value of the current time: Now. Return time, format as: 2012-09-23 06:48:28 Curdate, returns the date of the time, formatted as: 2012-09-23 Curtime, return time, format such

Original address: http://blog.csdn.net/k_scott/article/details/8167018This is my second tool for monitoring MySQL database performance: Spotlight on MySQLOur server database: is on the windows2003.This tool is very fancy, the interface is very

The analyzing thread is an analysis of the statistics of the MyISAM table (for example, ANALYZE table). The checking permissions thread is the one that checks whether the server has the required permissions to execute the statement. The Checking

Since the introduction of the InnoDB engine in MySQL, in MySQL support transactions, the transaction is a set of atomic query statements, but also a number of queries as a separate unit of work, usually by submitting a unit of work to complete the

Mysql Import and Export commands (Linux + Windows), mysql Import and ExportLinux environment: 1. First, check the mysql Data Storage path:Ps-ef | grep mysql   　　 　　 Ii. Enter the mysql Data Storage path found above:Cd var/lib/mysql(Data Storage path)

Describes how to implement multi-table database connection query and how to implement database connection query. Detailed description of how to implement multi-table database connection Query You can use the join operator to query multiple tables.

The idea and method of Mysql database Incremental backup, mysql incremental MySQL database Incremental backup. Before that, modify our database configuration file/etc/my. cnf to enable the bin-log function. Next, I have referenced some methods on