MySQL

As an extension of the SQL standard, MySQL also supports integer types tinyint, Mediumint, and bigint. MySQL int (m), m indicates that the display width is independent of storage, and int is 4 bytes.The signed int of the MySQL database can save 2^31-

Ext.: http://blog.chinaunix.net/uid-20639775-id-3323098.htmlIn System management or database management, it is often imperative to execute a command or SQL statement periodically. Anyone familiar with the Linux system knows the Cron scheduling task

1. Stop MySQL Service2. Delete all relay logs in the MySQL log directory3. Delete all hostname-relay-bin.xxx under Mysqldata directory, Hostname-relay-bin.index and Relay-log.info3. Restart MySQL Service4. Restart the master and slaveMysql> Show

Database encodingThe database uses a feature code to save data, such as Latin, Big5, GB2312, UTF8, etc., different languages generally use different encoding to saveCoding mainly affects the following two aspects:1. The amount of space occupied by

Recently just contacted MySQL, in the establishment of the expression encountered some problems, always prompt error code: The Can ' t create table ..., so I went to the internet to search for a bit of the following points to note:[CONSTRAINT

Reprint to Http://www.server110.com/mysql/201311/2991.htmlThe global shared memory is mostly MySQL Instance (MySQLD process) and the underlying storage engine is used to stage various global operations and shareable staging information, such as

First, mathematical functionsABS (x)Returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than x exp (x) return value E (base of natural logarithm) x

ref:http://blog.csdn.net/priestmoon/article/details/7677452Group_concat:group_concat(distinct name) group_concat(name separator ‘;‘)  // 默认是,group_concat(name order by name desc)SELECT * from Shelvesopbusinessrel;SELECT

Numeric Functions1, the remainder function mod (x, y)MoD (x, y) returns the remainder after X is removed by Y, and the MoD () also works for numbers with fractional parts, returning the exact remainder of the division operation.2. Function truncate (

In my project, the Connect database statement is written in the configuration file:where database is the name, data source is the server address where the database resides, "localhost" represents the local address, and port is the port number of the

One. Common MySQL command-line commands1. Start MySQL service net start MySQLStop MySQL service net stop MySQL 2. Netstat–na | findstr 3306 View the port being monitored, findstr is used to find out if there is a port in the back3. Log in to the

Introduction to the one or two binary logMySQL has different types of logs, where binaries record all modifications to the database, and if the database loses data because of improper operation or other reasons, it can be recovered by binary

I started the migration blog, the entire structure of the blog building and coding http://www.cookqq.com/lookBlog.action?id=c7d6978a-0dc0-4648-9020-2b81d859a243MySQL server recently always error, the content is as follows:The last packet

MySQL error code rollupMySQL error code1005: 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 causes

This article is a detailed analysis of the specific use of MySQL cursors, the need for a friend reference under Test table levelThe code is as follows:CREATE TABLE Test.level (name varchar (20));Insert some data again;InitializationThe code is as

Mysql error 1862 (HY000): Your password has expired., hy000expired Encountered error: ERROR 1862 (HY000): Your password has expired. To log in you mustChange it using a client that supports expired passwords. The reason is: MySQL 5.6

MySQL File Sorting & Index sorting Sorting is a very cpu-consuming operation. When the system is improperly set or the query retrieves too many fields, MySQL may have to discard the optimized sorting algorithm, however, the old sorting algorithm

Mysql reorganizes notes -- woods memo1. database 1. create database [if not exists] db_name [character set xxx] [collate xxx] * create a database named mydb1. Create database mydb1; * create a mydb2 database using the utf8 character set. Create

Mysql Study NotesMysql Study Notes1. installation environment:Windows 7Mysql 5.5 download from http://www.mysql.comEMS Mysql Query 1.6.0.1Local IP Address: 172.5.1.1832. Install Mysql by default.The directory is in c: \ mysql. do not modify the

Automated deployment of Mysql Distributed Database changes Automatic deployment of MySQL database changes   Overview:This Mysql database publishing program can automatically, quickly, and concurrently publish data changes and record results.