MySQL

MYSQL conversion coding solution 1. Obtain the hexadecimal encoding mysql> SELECT hex (CONVERT ('tourists' USING gbk) under gbk of the Chinese 'tourists' in mysql of utf8 )); -> D3CEBFCD www.2cto.com reversed gbk hexadecimal encoding and retrieved

SQL _mode system variables can regulate MySQL SQL mode. Any client can change the MySQL server's response to itself without affecting other clients.Www.2cto.com if you want to set the SQL mode when MySQL starts, you can add the SQL _mode option

Mysql solves the problem of automatic disconnection of connections that have not been used for nearly eight hours, I have done some experiments on this issue. The results of the study on mysql automatic disconnection at www.2cto.com are as follows.

After the primary key generation is configured in Hibernate for Mysql to generate UUID, the primary key generation mechanism is not specified in mysql. When using Navicat to insert data through SQL statements, you still need to specify the Id,

Mysql slimming method Note: 1. before performing this operation, stop the Database Service and copy the mqslq5 folder for backup. install the Database Connection Tool navicate on the computer where the database is located; 3. delete useless

Mysql logical backup mysqldump Syntax: mysqldump [arguments]> file_name if you want to back up all databases, you can use the -- all-databases option: mysqldump -- all-databases> dump. SQL www.2cto.com if you want to back up the specified database,

Mysql DATA import method mysqlimport 1). mysqlimport Syntax: www.2cto.com mysqlimport is located in the mysql/bin directory and is a very effective tool for mysql to load (or import) data. This is a command line tool. There are two parameters and a

Linux MySQL source code compilation and Installation System Platform: Ubuntu12.04 compiling environment: gcc-4.6.3 preparation work: www.2cto.com mysql-5.5.28.tar.gz cmake-2.8.10.2.tar.gzncurses-5.9.tar.gz because of mysql5.5 or above version

[Data sorting] MySQL error number meaning MySQL error number is retained for future reference. Www.2cto.com 1005: Table creation failed 1006: database creation failed 1007: database creation failed 1008: database creation failed 1009: Database

For mysql database cold backup, note that cold backup refers to a complete database provided when the database is shut down normally. Cold backup is a way to copy key files to another location. Advantages: www.2cto.com 1. is a very fast backup

Mysql logon problems occur in Windows. when mysql is logged on, the following ERROR occurs: ERROR 1045: Access denied for user: 'root @ localhost' (Using password: YES) www.2cto.com found some solutions from the Internet and finally got a solution.

Example of a MySql stored procedure: SQL code www.2cto.com CREATE DEFINER = 'root' @ '% 'Procedure 'proc _ calculate_combo_price' (IN 'comboid' VARCHAR (36), OUT 'price' DOUBLE, OUT 'reallyprice' DOUBLE) language SQL not deterministic contains SQL

Solve the 1093 error in modifying table records in mysql. requirement: known TABLE information: TABLE Name: frjg TABLE structure: [SQL] DROP TABLE IF EXISTS 'frjg'; CREATE TABLE IF NOT EXISTS 'frjg' ('id' int (11) not null AUTO_INCREMENT, 'jgbh'

Summary of MySql logical Backup Recovery Method 1. Mysql logical Backup 1. use mysqldump command to generate INSERT statement backup this method is similar to the oracle expdp \ exp tool Syntax: mysqldump [arguments]> file_name. SQL help: [root @ gc

In Windows, MySQL executes SQL script files in batches recently for database migration. It is too difficult to manually execute MySQL script files in batches, so I wrote a script to share it. 01 @ echo off02: Specify the MySQL installation path 03D:

Install mysql compressed package record install mysql record [root @ eegooserver3 ~] # Groupadd mysql [root @ eegooserver3 ~] # Useradd-g mysql [root @ eegooserver3 ~] # Cd/opt [root @ eegooserver3 opt] # tar zxvf

MYSQL obtains the auto-increment ID in four ways. select max (id) from tablename 2. the SELECT LAST_INSERT_ID () function LAST_INSERT_ID is irrelevant to table. If data is inserted to table a and then to table B, LAST_INSERT_ID changes. Max (id) is

Millions of SQL optimization Summary 1: Basic Environment 1: Database: Mysql2: Table Structure 3: data quantity: 500 + 2.1 2: Objective: original SQL statement selectzero_dateline, sum (item_amount) as 'sum' from c_log_item where item_id in (bytes, 1

Some maintenance tasks for mysql 5.6 partition maintenance tables and partitions are applicable to the use of SQL statements on mysql partition tables. To maintain a partition TABLE, you can use statements that support partition tables: check table,

MYSQL uses Limit to Limit the number of updated rows to modify the config table. Change is_ OK of row 5607 to true. The following SQL statement is used to implement the SQL code UPDATE channel_config set is_adam_pub = 1 where channel_id in (select