MySQL

Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be investigated.

Not a null constraint.The NOT NULL constraint can only be declared after the column name, cannot be declared with the constraint statement, and of course there is no way to declare the constraint name. The change field is NULL or NOT NULL only with

This article summarizes all of the tools associated with MySQL DevOps development and will continue to update1. Tool Suite SetPercona-toolkit:http://www.percona.com/software/percona-toolkit Oak-toolkit:http://code.openark.org/forge/openark-kit

After the 1.MySQL field specifies the type, the storage is fixed-length, and the Int (1) and int (4) are the same from their own lengths or stored methods. In MySQL, the difference between int (1) and int (4) is the length of the display, but to set

1. Follow the prompts to install the MYSQL2. Run cmd into the MySQL installation directory, my installation directory C:\Program files\mysql\mysql Server 5.6\bin input CD C:\Program files\ Mysql\mysql Server 5.6\bin3. Using mysqld to register

Used to think that Mysql,innodb_buffer_pool_size=8g,mysql together will take up 8G of memory (think top can see the memory is used 8G), but recently carefully studied, it is not the case (perhaps their own Linux malloc memory allocation just knows a

The source code is as follows: Import java.sql.*; public class Contomysql {public static void Main (string[] args) {Here "Liuyan" is a test database built under MySQL.3306 is the default port for MySQL database serviceString url=

Today get a server, want to deploy the project, the results found that MySQL has been installed, while the password forgotten. Tragedy, the original was not apt-get installed, resulting in the deletion will not clean.There is no way, only to

                                 Master-slave replication One, How master-slave replication works MySQL the process of implementing the entire replication between master and slave is done by 3 threads, of which two threads (SQL thread and IO thread)

OverviewThe rows in MySQL are index-based and row locks are locked on the index, so if a field is not indexed, it cannot be locked. This paper is mainly to implement the verification process.1. Using the InnoDB engine to build a tableMysql> Create

#!/bin/shlog=/var/log/mysql-backup.log# MySQL db infouser_root=xxxxxxuser_pwd=xxxxxxx# mysql data stored dirTODAY= ' Date +%f ' storedir=/mnt/tf-card/mysql-back/$TODAYmkdir $STOREDIRecho "* * * PATH: $STOREDIR mysql-backup * * *" >> $ log# Delete

Environment:Master ip:192.168.10.10Salve ip:192.168.10.201) Install MySQL on both machines.2) Modify Master my.cnf to add the following linesServer-id = 1Log-bin =/opt/mysql/log/mysql-bin.logDataDir =/opt/mysql/dataInnodb_flush_log_at_trx_commit =

Today, with MySQL's sub-table problem, you can use scripting to iterate through the creation of a new table, or you can build it using SQL. The following is an example of establishing a player_0 to player_9 statement.Delimiter//CREATE procedure

The whole idea of scripting1. Define the required variables2. Use the For loop to back up the library that needs to be backed up and name the library-the date of the day. SQL naming and logging of related logs3. Set up a directory for the date of

Install opesntack MySQL ErrorError:error appeared during Puppet run:192.168.1.103_mysql.pperror:mysqladmin-u root password ' f40e1dec1deb43d3 ' returned 1 instead of one of [0]# Rpm-qa | Grep-i MySQLMysql-server-5.1.71-1.el6.x86_64Perl-dbd-mysql-4.01

Explain profilingIt is recommended to provide the following informationShow table status like ' audit ';Show create table audit;Show index from audit;Check table audit;Analyze table audit;Analyze does not check the table for problems, just

The MySQL client is on the DOS interface, but the default character set encoding for the DOS interface is: GBK(1). MySQL character conversion schematic diagram(2). View all of the server's encoding methods:>show variables like ' character% ';(3).

MySQL Replication (replication) is an asynchronous replication that replicates from one MySQL instance (Master) to another MySQL instance (Slave).         Implementing the entire master-slave replication requires the IO process on the master server,

Example of input and output parameters of mysql Stored Procedure drop PROCEDURE if exists my_procedure; create PROCEDURE my_procedure(in my_id int,out my_name char) BEGIN select list_name into my_name from aa_list where list_id=my_id; end; call my_

How does mysql Merge multiple rows into one row and mysql multiple rows? Select group_concat (list_name) from aa_list How to merge multiple rows of data into one row in excel If you want to merge data of A1, A2, and A3 into one row, enter the