MySQL

Tag:sts   class   return   ring    Auto     iconv   des   param   func    _ooooo_//o8888888o//88 ". "88//(| -_- |) o\ =/o//____/'---' \____//. ' \\| |//'.///\\| | | : ||| // // / _||||| -:- ||||| - // | | \

MySQL Master-slave replication principleMysql Master-Slave synchronization is actually an asynchronous replication process, in order to achieve replication first need to open the Bin-log log on master, the entire process needs to open 3 threads,

Initialize database default command:./scripts/mysql_install_db--user=mysql--datadir=/data/mysql Error message:-bash:./scripts/mysql_install_db:/usr/bin/perl: Bad interpreter: No file or directory, Workaround: Yum Install

This article explains in detail the use of the ALTER command in MySQL syntax, which is a much more useful syntax, and the functionality is very powerful. Use Learning (to be built in advance) CREATE TABLE INT not NULL , CHAR (tennotnull, INTis

Attached: MySQL Common error code description1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed1008: Database does not exist, delete database failed1009: Unable to delete database file

1. Create a connection pool:Why was it created? Because the database is expensive to create connections to the server each time, if a lot of people want to connect to the database, each user creates a connection and the performance is greatly

Data types in MySQL1. Integral type MySQL data type Meaning (Signed) tinyint (m) 1 byte range ( -128~127) smallint (m) 2 byte range ( -32768~32767) Mediumint (M) 3 byte

#!/bin/sh#user_db= "root" pass_db= "passwd" host_db= "localhost" name_db= "mysqlname" port= "3306" ls/bak/mydata/& >/dev/nullif [$?-ne 2];thenmkdir-p/bak/mydata &>/dev/nullfi/usr/bin/mysqldump--opt-u$user_db-p$passwd_ Db-h$localhost-p$port $name _db

The letter-case rule in the MySQL statement varies with the statement element and depends on the operating system on the MySQL server host.SQL keyword and function nameKeywords and function names do not distinguish between uppercase and lowercase

An introduction to IDE toolsThe production environment is also recommended for MySQL command line, but for our testing purposes, you can use the IDE toolsDownload Link: https://pan.baidu.com/s/1bpo5mqjMaster: #1. Test + link Database # #. Create a

Service, of course, can not be separated from the database, if you see the data on the cry, I suggest you still look at this article, do not do data cry ah hahaTo do ' data cool ', hahahaAn installation1. Wget-i-C

What is a MySQL trigger, let's look at the meaning of the trigger first. The literal meaning of a trigger is a reaction triggered by a touch.MySQL must know that the trigger is interpreted as a MySQL statement (or a set of statements between the

1. Add Table record Insert a record: Insert [into] tab_name (field1,filed2,.......) VALUES (value1,value2,.......);　　　　　　　　　　　　　　　　　　　　　　　　　　　　 Insert multiple records: Insert [into] tab_name (field1,filed2,.......) VALUES (value1,value2,.......),

PHP//header ("content-type:text/html; Charset=utf8 ");//header (" Content-type:text/html;charset=utf-8 "); $end=Array();$d=$_post[' ID '];//$d = $_get[' id '];if($d==NULL){ $end[' State ']= '-1 '; $end[' msg ']= ' Please enter ID ';

CentOS Setup MySQL Character setVim ETC/MY.CNFModified to read as follows:[Client]port=3306Socket=/var/lib/mysql/mysql.sockDefault-character-set=utf8[Mysqld]Datadir=/var/lib/mysqlSocket=/var/lib/mysql/mysql.sockUser=mysql# Disabling Symbolic-links

We, as DBAs at work, may also need to face the various freestyle of developers, but do they know what to look for when working with databases?Today with everyone simple talk about MySQL database development behavior norms, the ten iron discipline.

MYSQL-INNODB scenarios where asynchronous IO is usedIn general InnoDB only uses asynchronous IO for data files, in order to save logs that are actually written to disk, InnoDB does not enable asynchronous IO for log filesUpdate in one step, InnoDB

Mysql determines whether to insert data based on the conditions, and mysql inserts data based on the conditions. This problem is actually divided into two aspects: 1. Determine whether to insert data based on the table's primary key. 2. Determine

MySQL binlog data recovery, mysqlbinlog We have learned how to enable binlog of MySQL and the principles and common operations of binlog. We know that binlog has two major functions: Use binlog to restore data, the other is for master-slave

Mysql security, mysql 1. Set the directory permission correctly:The principle of setting directory permissions is to separate software from data, as follows:1. Install mysql under a separate user2. During installation, the installation is performed