MySQL

1, first through the command line statement SHOW VARIABLES like ' character_set_% '; We know that MySQL's default encoding is Latin, that is, latin1, and this method is not supported in Chinese, once the Chinese data is stored, it will be an error!A

#!/bin/sh# File:/data/backup/dhdatabak.sh# Write By:sandy# Last Modify:2013-09-11# Database InfoDb_name= "Osite"Db_user= "USER"db_pass= "PWD"# Others VARsBck_dir= "/data/backup/dhdata"Date= ' Date ' +%y%m%d-%h_%m

The number of milliseconds in a timely manner when the time type stored in the database is of type bigintIn Java:New DATE (). gettime ();//The number of milliseconds to get the timeWhen you need to convert the number of milliseconds to timeIn

MySQL Incremental recovery processCreate a table for testingMysql> CREATE table User (name char (ten), age int (3)); Query OK, 0 rows affected (0.07 sec) mysql> desc user;+-------+----------+------+-----+---------+-------+| Field | Type | Null | Key

MySQL replication can be easily used to do the application of the read extension, can also help MySQL to achieve a certain degree of HA program. MySQL implements replication by transmitting binary logs to the repository, which is explained by the

There are two ways to manipulate a database using PHP Using the Mysql_xxxx () method In this way, you need to remove the Extension=php_mysql.dll from the php.ini first. Using PDO To use this test, you need to

1.ERROR (HY000): Lost connection to MySQL server at ' reading initial communication packet ', System error:0Tcpwarpper blocked, edit/etc/hosts.allow, plus these two lines#/etc/Hosts.allowsshd:ALL:ALLOWmysql:ALL:ALLOWThis error also has the

Start the command line first1. Run at the command line:taskkill/f/im Mysqld-nt.exeThe following operations are operating in the MySQL bin directory under some programs, if not configured environment variables, you need to switch to the MySQL bin

This article introduces the use of the Group_concat function in MySQL, such as select Group_concat (name).Group_concat function in MySQLThe complete syntax is as follows:Group_concat ([DISTINCT] field to connect [order by Asc/desc sort field]

Reprint Please specify source: http://blog.csdn.net/guoyjoe/article/details/45848057#!/usr/bin/env python#-*-Coding:utf-8-*-#导入模块Import MySQLdbImport timeImport datetimeImport OS"""Purpose: Backing Up the

Experimental Purpose: use Keepalive to build Mysql 's high availability. MySQL is the master from when a MySQL outage does not affect the call to MySQL . Lab Environment: two mysql servers (LAMP -based and master- slave ), both MySQL servers are

Enterprise Face question 1: (production case): monitor MySQL master-slave synchronization is abnormal, if abnormal, send sms or mail to the administrator. Note: If there is no master-slave synchronization environment, you can use the following text

Today's use of the Timestampdiff () function in the project requires the processing of a single piece that scans the scan time to a current time greater than 24 hours. The following values summarize the usage of the Timestampdiff and Timestampadd

I wrote an article about this before.Why does "original" use data indexing to improve efficiency? (This article provides an overview of MySQL) (update)This time, the main focus is on two common storage engines.We generally perform MySQL database

The use of indexes in MySQL and the SQL types that actually use Indexes 1. Why are indexes used? Without an index, MySQL scans the entire table to find records that meet the SQL conditions. The time overhead is positively related to the data

MySQL index and optimization QueryAn appropriate index can accelerate the query speed. There are four types: primary key, unique index, full-text index, and common index.Primary Key: It is unique and has no null value.Create table pk_test (f1 int

MYSQL database Naming and Design Specifications1. Design Principles 1) standardization and standardizationData Standardization helps eliminate data redundancy in databases. There are several forms of standardization, but Third Normal Form (3NF) is

The founder of the technology company talked about the future of MySQL As the stable version of MySQL 5.7 is approaching its official release, we have joined various MySQL branches to continue to compete for market share. We interviewed Peter

Mysql sorts the output result with the specified ID number SELECT * FROM 'cms _ hit' WHERE aid in (55,173,177,174,175,176) Generally, the specified ID of the SQL output needs to be sorted, and the output of the above results has certain

Detailed process of using mysqld_multi to deploy a single-host multi-instance Preface: Multi-instance? Why?   With the development of hardware, multi-core linux systems have become a general trend, while mysql is a single-process multi-thread, so