MySQL

Transferred from: http://www.cnblogs.com/zbseoag/archive/2013/03/19/2970004.html1. Integral type MySQL data type Meaning (Signed) tinyint (m) 1 byte range ( -128~127) smallint (m) 2 byte

Linux Systems:Under Linux, the default data document storage directory for MySQL is/var/lib/mysql. The following steps are required if you want to move the MySQL directory to/home/data:1. Set up the data directory in the home directoryCd/homemkdir

Originally thought the data came out, to show is a trivial thing! Who knows, I made a day .... I was wrong in not putting connection.query inside.The following example is possible! Read my previous article of the classmate, should be very familiar

In my opinion, hibernate is the most troublesome thing is to configure the Foreign Key association, a slight error will appear configuration errors, the current project is all in the use of mybaits, and mybaits use is much simpler, at least,

A long time ago to build a multi-instance of MySQL, remember that was very smooth, hehe! Today the company because of business needs, I set up a multi-instance. After MySQL is installed, when initializing two instances, the following error occurs:150

MySQL backups typically take full backups plus log backups, such as performing a full backup every day, and a binary log backup every hour. This allows you to recover data to any location or time prior to the last binary log backup using full backup

First, select an identifierOnce a type has been selected, to ensure that the same type is used in all associations, the exact match between types is required, including properties such as unsigned.Issue: Implicit type conversions can also cause

MySQL, database encoding is a very important problem, sometimes we need to look at the current database encoding, and even need to modify the database encoding.The SQL statements that view the current database encoding are:mysql> use xxxdatabase

#!/bin/bash# author: movekj# descript: backup mysql. full backup in  sunday,incremental backup in other day. (for innodb store engine) # version: 0.0.1 ### define variablespath= "/

Because MySQL has a variety of database backup methods, and each has its pros and cons, for us beginners, choosing the right backup method is indeed a bit difficult. Personally think, first of all, based on the company's needs, consider the ability

2015-10-25DirectoryResources[1] Tang Hanming. mysql database development, optimization and Management Maintenance (2nd edition) [M]. Beijing: People's post and Telecommunications press, 2014[2] Schwartz. High-Performance MySQL (3rd edition) [M].

MySQL field typeMySQL supported data types--string typesNumber Type Column type The amount of storage needed Scope, remarks TINYINT 1 bytes 一个很小的整数The signed range is 128 to 127, the unsigned range is 0

1 installation of necessary related packagesYum-y Install kernel-devel openssl* popt popt-devel2 Download and installwget http://www.keepalived.org/software/keepalived-1.2.9.tar.gzTAR-XF keepalived-1.2.9.tar.gzMkdir/usr/local/keepalivedCD

Transferred from: http://linux.it.net.cn/CentOS/course/2014/0724/3319.htmlVersion Glassfish-4.0.zip1, unzip, copy to the specified installation path Unzip Glassfish-4.0.zip CP CP glassfish4/usr/local/-RF 2. Setting

One, install homebrewLike Yum under Linux, Mac has a homebrew, and it's easy to manage software.Official website: http://brew.sh/index_zh-cn.htmlThere is a command, copy down the terminal to execute, if the command returned 404 Not Found, the

Original address: http://koda.iteye.com/blog/682547MySQL's master-slave synchronization mechanism is very convenient to solve the high concurrent read application requirements, the development of the web has brought great convenience. However, there

MySQL Database optimization Summary-----duDescription: The environment for this article is CentOS 5.5 bit/mysql 5.1.50Introduction: The use of MySQL for some time, during the period did a lot of MySQL optimization, design, maintenance work, the two

1. Global & DynamicExample:slow_query_log? Display the value of the variable:Currently set to OFF? Set the variables of the global &dynamic type in a session:As you can see, a variable of type global must have its value set by the Global keyword. ?

MySQL Study--mysql cannot start "Mysql.host"System Environment :Operating system: RedHat EL55DB Soft:mysql 5.6.4-M7after installing MySQL from the source package, an error occurred while booting mysqld: [email protected] mysql]# Bin/mysqld_safe &[

Php+mysql causes of Chinese garbled:1. mysql database encoding is UTF8, and PHP Web page encoding format inconsistent, will cause MySQL in the Chinese garbled.2. Using MySQL to create a table, or select a field when the type is not utf8, and the