MySQL

Mysql Query Note1. In the MySQL query need to pay attention to the table in front of the database prefix , or the default is the current database (when more than one library query, may appear repeatedly check the same table multiple times)2. \!

As previously seen in an article, if you want to know who landed your database server and what you did, then you need to use Mysql Enterprise Audit plugin. Here 's how to use Mysql Enterprise Audit plugin:Method One:1. Find audit_log.so in your

1. Slow Query functionSlow queries can help us record all SQL statements over Long_query_time, which facilitates SQL optimization.2. Check the open status of slow queryBefore you start a slow query, you need to determine if the slow query is turned

A few days ago, a team of the company's colleagues responded that the company's internal Linux server MySQL did not innodb this engine, I thought it should not be possible ah, MySQL default should have installed this engine, so on the server to look

Database encoding table encoding IDE encoding must be consistent, can solve the problemScenario: Import this data into the database and get the first letter of the city name PinyinImport data from Excel to MySQL, using the JXL libraryThe PINYIN4

The previous MySQL daily backup shell script gives a script that uses mysqldump to back up to the local, followed by a script that uses FTP to transfer the backup file to the remote server. Of course, can also use Scp,rsync and so on plan.

Using Nodejs+mysql is certainly better for server-side development than a combination of PHP and MySQL.Using Nodejs you will benefit from his asynchronous behavior. For example, to improve performance, you don't have to get a performance boost from

shell-mysql (1) Script background: Because to be on Linux, remote read MySQL table data, and then do a certain cleaning, upload data to the Hadoop cluster, use Java to write it, feel too troublesome, have to develop on win, also have to play into

In MySQL, two strings added cannot use the + sign, plus is used to add numbers, in MySQL to connect strings need to use the concat or CONCAT_WS function: Mysql concat functionGrammar: CONCAT (Str1,str2 ...) For example: Select Ocncat (' AB ', ' CD ')

MyBatisis one that can be customizedSql, stored procedures, and a persistent layer framework for advanced mappings. MyBatisexcluding most of theJdbccode, manually set parameters, and result sets are re-obtained. MyBatisuse only the simpleXmland

In the development of the problems encountered in the first few days, during the debugging process found that the configuration service this transaction does not work layer, after the update database throws an exception or success, the transaction

When MySQL is compiled and installed, it is sometimes found that the InnoDB storage engine is not supported when the installation is complete, because the parameters that support InnoDB are missing when compiling the installation:

A server installed two versions of MySQL, through the shell landing, how the log is 3306 this.How to view port numbers in MySQLShow variables like ' Port 'Online check of Add-P--port also not,Later I searched carefully, the original and

From:http://www.jbxue.com/db/758.htmlImplementing MySQL Monthly Statistics tutorialMySQL has a field is a DateTime type, to implement can be counted by month , how to write SQL statement?Select Month (F1) from the TT Group by month (F1)OrSelect Date_

1. Numeric class data column type Data column type Storage space Description Range of values TINYINT 1 bytes A very small integer Signed Value: -128~127Unsigned value: 0

1, initialize the module.When MySQL is started. Initializes the module to take over control.Initializes the module. Read the configuration file. command-line arguments.Allocate the global memory cache, initialize global variables, structure

The storage engine is the MYSQL component that handles SQL operations for different table types. InnoDB is the default, most versatile storage engine, and is also the official recommended storage engine, unless some specific cases are used. The

Objective:The recently developed iOS project, because of the need for user text storage, naturally encountered an issue where emoticons such as emoji were supported by MySQL DB. Troubled for a few days, on the verge of desperate abandonment, finally

Current_timestamp is synonymous with now, meaning the two are the same.The Sysdate function returns the time it takes to execute to the current function, and now returns the time when the SQL statement was executed.Test statement:SELECT now (),

Preface: The previous article on the transaction processing of the post did not write clearly, read it is very obscure, difficult to understand, so there are some information to help understand, forgive me!About MySQL transaction processing learning