MySQL

1. View Character Set settingsMysql> Show variables like ' collation_% '; +----------------------+--------------------+| variable_name | Value |+----------------------+--------------------+| collation_connection | Utf8mb4_unicode_ci | |

There are two main ways in which MySQL transactions are handled: 1, with Begin,rollback,commit to achieveBegin a transactionROLLBACK TRANSACTION RollbackCOMMIT TRANSACTION Acknowledgement2, directly with set to change the MySQL automatic submission

There are a lot of tutorials on MySQL online, but none of them are up to date, I just have a brief description of the latest version of my SQL installation and setup, and most of the operations are the same.The following is described in accordance

The previous article thanks to "Mysql, MariaDB traditional master-slave cluster Configuration", the technology has been very mature. Starting from Mysql5.6 and MariaDB10.0, with the new master-slave scheme Gtid, but the two systems to this version

To connect to the MySQL database:The main view of MySQL installed in which directory:Mysql-h host Address-u user name-P user password or mysql-h IP address-u zaiai-p zaiai or/var/email/mysql/bim/mysqlSQL Modify field type in MySQL databaseFirst of

Website Introduction:http://www.tangentsoft.net/mysql++/mysql++ is a C + + wrapper for MySQL ' s C API. It is built around the same principles as the standard C + + Library, to make dealing with the database as easy as dealing W ITH STL containers.

Features of the InnoDB engine table1, InnoDB engine table is a B + tree-based index organization table (IOT)About B + Trees(Image from the Internet)Features of B + trees:(1) All keywords appear in the list of leaf nodes (dense index), and the key

Recently, the customer has a demand, the younger brother for the operation of the thing is also dabbler, so determined to explore the next. It was a night of torture and finally it was done. Because is two different server, originally wanted to use

MySQL How to export only the table structure and data for the specified table (go) 2011-01-04 15:03:33Category: MySQLHow MySQL only exports table structure and data for a specified tableThe table structure for exporting a more library is as

Http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-passwordMysql-resetting a lost MySQL root passwordThe MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken

Optimization of Max ()For example: Explain select Max (' Payment_date ') from payment; The number of rows that can be viewed to row is very much, which means that the entire table is scanned.Add an index to payment_date.CREATE INDEX Idx_payment on

1. Set the default character value for the fieldALTER TABLE ' v_users 'MODIFY COLUMN ' picture ' varchar (a) CHARACTER SET UTF8 COLLATE utf8_general_ci NULL DEFAULT ' 3.jpg ' after ' phone ';Note that when you set the default value for the Picture

Introduction to MySQL performance optimizationWhat is performance optimization? In fact, we tend to define from a broad sense that the non-functional optimizations of a MySQL system will be considered performance optimizations, such as the stability

MySQL read-write separation--mysql-proxy and amoebaStatic Detach: Writes the server address directly to the programDynamic separation: Through the proxy server to read and write data, the proxy server to determine the read and write operations, on

Turn from: http://hi.baidu.com/cnvienna/blog/item/2e99efdfd94fc61862279801.htmlMySQL will appear in Chinese garbled reason is the following points:1The server itself sets a problem, for example, to stay in Latin12. Table language setting issues

1 Select two servers, respectively, as a master and standby database2 Login to the server,Yum install MySQL;Yum install mysql-server;3 Starting the serverService mysqld Start4 separate root login MySQL to execute the following command, increase the

More count_table_count.sh#! /bin/bash>table_count.txtmysql-uroot-p123123-h192.168.10.100-e "use rrmj;show tables;" | Sed '/tables_in_rrmj/d;/category/d;/duplicate_user/d;/login_user/d;/resource/d;/resource_category_rel/d;/

Command line Export database:1. Go to the Bin folder in the MySQL directory: cd MySQL to the Bin folder directoryAs I entered the command line: CD C:\Program files\mysql\mysql Server 4.1\bin2, Export database: Mysqldump-u user name-p database name >

1. The use of Annotation is mainly divided into 2 steps:1.1 Add the appropriate jar package:Hibernate-annotations.jar// Annotation Core PackEjb3-persistence.jar// implementation of Annotation compliant with JPA standardsHibernate-commons-annotations.

Recently started a Raspberry Pi, a whim to make a small home server, at home for the hour has been hanging.　Really is very small, only slap big, to Raspberry Pi bought some accessories, shell, small fan, 2 fins, 32G SD card, HDMI line, after the