Introduction:MySQL is widely used in projects because of its free and open source nature. As we all know, a MySQL database can store a large amount of data, if you want to find a large amount of data, if the use of full-table retrieval, that is,
Source Address: http://www.blogjava.net/zyskm/archive/2013/04/09/361888.html The concept of a character set everyone knows, proofing rules many people do not understand, the general database development is also not used in this concept, MySQL in
First, the development environment
Win8.1 64-bit, VS2013, MySQL5.5.3764-bit
the MySQL installation directory is: C:\Program files\mysql\mysql Server 5.5
Second, the configuration of the engineering environment
First
Reprint Address: Http://www.2cto.com/database/201212/177382.html the features and functions of a custom Function (UDF) www.2cto.com functions can be divided into return strings, integers or real numbers; can define a simple function
Preface * DRBD (distributedreplicatedblockdevice) is an open source software that synchronizes and mirrors data directly on a remote server based on the block device level. Similar to RAID1 data mirroring, typically with HA software such as
Dotconnect for MySQL is completely based on the ADO method, so you can use it in a way that standard ADO data provides. is a data generator control that provides direct MySQL database connectivity for the Microsoft. NET Framework.Data generator,
Linux mysql installation fails to start./etc does not have a mysql configuration file,
Mysql cannot be started,/var/run/mysqld. sock or/temple/mysqld. sock cannot be found
Confirm and manually install the following software
My experiences with MYSQL (7)
My experiences with MYSQL (1)
My experiences with MYSQL (2)
My experiences with MYSQL (III)
My experiences with MYSQL (4)
My experiences with MYSQL (5)
My experiences with MYSQL (6)
In this "my MYSQL learning
1. Set the character encoding of MyEclipse as follows: 1. go to Window -- Preferences -- General -- Workspace, and change the Default (GBK) option in the Text file encoding option to Other, set the value to UTF-8;
2. go to Window -- Preferences --
LIST partitions of mysql partitions
LIST partitions in MySQL are similar to RANGE partitions in many aspects. Like partitioning by RANGE, each partition must be clearly defined. The main difference between them is that the definition and selection
I recently read some architectural materials, but found that the basic knowledge is not very strong. In the next period, I will summarize the basic knowledge on a regular basis.
I. Data Types
1. Integer
Data Type
Storage space
Therefore, such errors often occur.Copy codeThe Code is as follows:Select * from [IND] where INDID> 10UnionSelect * from [IND] where INDID So far, no questions have been asked
Later, someone may use similar queries.Copy codeThe Code is as
After a mysql upgrade, mysql on the development machine is upgraded to mysql 5.6. As a result, the following exception is reported when the mysql server of some earlier versions is connected:Warning: mysql_connect (): Connection using old (pre-4.1.1)
1 install mysql
See http://www.jb51.net/article/47094.htm
2. Basic configuration of master 1
3. Create usersGrant replication client on *. * TO 'mmm _ monitor' @ '% 'identified BY 'mmm _ monitor ';Grant super, replication client, process on *. * TO '
How to Create a memory table?Creating a MEMORY table is very simple. You only need to specify ENGINE = MEMORY:Copy codeThe Code is as follows:Create table 'tablename' ('columnname' varchar (256) not nul) ENGINE = memory default charset = latin1
5. sort and retrieve data
5.1 sort data
ORDER
SELECT prod_name FROM products ORDER BYprod_name; // sort search
SELECT prod_id, prod_price, prod_name
FROM products ORDER BYprod_price, prod_name; // sort by multiple columns
5.2 specify the sorting
Different from row-level or page-level locking options:· Version (for example, the technology used to insert data in MySQL in parallel), which can be a write operation with many read operations at the same time. This indicates that the database or
An ERROR 1418 is reported when you create a function in MySQL. You cannot create a function. According to the official prompt, the failure to create a function may be a security configuration or the function is not enabled. Let's take a look at
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service