MySQL

Handling MySQL SLAVE synchronization error discussions using parameter Sql_slave_skip_counterThis article link address: http://blog.chinaunix.net/uid-31396856-id-5753206.htmlThis article discusses using Sql_slave_skip_counter to cause SQL threads to

Docker version:[email protected] ~]# Docker versionclient:version:1.10.3API version:1.22Package version:docker-common-1.10.3-46.el7.centos.10.x86_64Go version:go1.6.3Git commit:d381c64-unsupportedBuilt:thu 4 13:21:17

Delimiter $create PROCEDURE phonedeal () BEGIN DECLARE ID varchar (+); --ID DECLARE phone1 varchar (+);--Phone DECLARE password1 varchar (32);--Password DECLARE name1 varchar (+); --ID --traverse end of data flag DECLARE

Select Concat_ws ("_", Name,password) as name from ' user ';Select Group_concat (Name, ":", password) as name from ' user ';One, CONCAT () functionThe CONCAT () function is used to concatenate multiple strings into a single string.Use data table

1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p dbname users>

MySQL database knowledge points1. Manage Database statements:Working with databases:Use test;To add a database:Create database name;Create DATABASE test;To modify a database:ALTER DATABASE name;ALTER DATABASE test;To delete a database:drop database

mysql-data table Mysql-create table creationTo create a new table in the database, you can use the MySQL CREATE TABLE statement.CREATE table [IF not EXISTS] table_name ( column_list #在 column_list section specifies a list of tables. )

Mysql> Select Id,avatar from tf_user;+----+--------------+| ID | Avatar |+----+--------------+| 1 | Avatar_1.png | | 2 | Avatar_6.png | | 3 | Avatar_1.png | | 4 | Avatar_5.png | | 5 | Avatar_5.png | | 6 | Avatar_4.png | | 7 | Avatar_6.png | |

1.mysql master-Slave backup FundamentalsMySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers. MySQL replication tracks all changes to the database

Transfer from https://www.jianshu.com/p/628bcf8bb557As of MySQL 5.7.18, is my-default.ini no longer included in or installed by distribution packages.MySQL no longer comes with the default configuration fileJust write one manually.Cd/etcsudo vim

Case Description:Two operators of the bank operate the same account simultaneously.For example, A, B operators simultaneously read a balance of 1000 yuan account, a operator for the account increase of 100 yuan, b operator at the same time for the

yumthe general version of MySQL installed is older, but it runs stably. If you want to try the latest features or you need to specify special features, you need to manually compile the installation.First, download the installation package(a), first

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

Reference: http://blog.csdn.net/zbw18297786698/article/details/52999940Description: 192.168.3.81 CentOS release 6.5 apache-activemq-5.10.11. Copy the MySQL drive to the ACTIVEMQ environmentMysql-connector-java-5.1.44-bin.jar[Email protected]

Data typeTruncate t1 (delete table) # unsigned type ALTER TABLE t1 modify ID tinyint unsigned (table has value, cannot be changed directly) desc t1======================================== tinyint[(m)] [unsigned] [Zerofill] small

Using the source code installation, can add some parameters according to the actual production environment, improve MySQL performanceMySQL official website https://www.mysql.com/This article uses the 5.1 version of the dedicated installation

!!! It is important to analyze the deadlock principle and the deadlock principle. Original Link Author: Desert solitary smokeBackground and Symptom In the online production environment, database operation deadlocks often occur in some cases, and

Mysqli execution of mysql transactions Public static function exec_ SQL _tran ($ arr_ SQL ){ $ Result = true; $ Con = new MySQLi (DBHOST, DB_USER, DB_PASSWD, DB_NAME ); $ Con-> autocommit (FALSE ); Foreach ($ arr_ SQL as $ key => $ SQL ){ If (! $

How to enable slow log query in MySQL In Windows, find the my. ini file in the MySQL installation directory. The mysql version I use is earlier than 5.1.40. Add the following lines in my. ini: MySQL Method for enabling slow log query [Mysqld]

How to Use the MYSQL Command Line for beginners MYSQL beginner's guide and introduction 1. Connect to MYSQL. Format: mysql-h host address-u user name-p User Password 1. Example 1: connect to MYSQL on the local machine. First, open the DOS window,