MySQL

First of all, the MySQL character set problem. Windows can be modified by modifying the My.ini in the # CLIENT Section [MySQL] Default-character-set=utf8 # SERVER Section [Mysqld] Default-character-set=utf8 These

bigintInteger data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes.p.s. bigint already has length, in MySQL build table length, just used to display the number of digitsIntInteger data

Change MySQL promptmysql> prompt \[email protected] \r:\b:\sFind to my database starting withMysql> show databases like ' my% 'Delete all UsersMysql> Delete from Mysql.user;Add User RightsMysql> Grant all privileges on * * to [e-mail protected] '% '

To see how to solve the garbled problem:In MySQL, the default character set is Latin1,If you want to set the character set to Uft-8, you can add the following settings in the My.cnf

1. MySQL's Way and differenceHow to troubleshoot when MySQL boot encounters a problem/etc/init/d/mysql Start | Restart | Stop this script is generally installed after the automatic generation by mysql.server, if it is directly decompressed using the

An error occurred while updating the root password todayUpdate user set password= ' 123456 ' where user = ' root ' is wrong to writeShould be update user set password = password (' 123456 ') where user = "root"The MySQL database disappeared after

Note: This article is reproduced from http://www.hollischuang.com/archives/914In computer science, a lock is a synchronization mechanism used to forcibly restrict access to resources when executing multiple threads, which is used to guarantee the

Using Yum to manage the installation of the Apache+php+mysql+jdk+tomcat, it's quick and easy, plus some security for Mysql, and notice that the fire wall has opened the relevant port, otherwise it is never connected.This is a successful installation

Using electron to create MySQL data compare to tool project originWorking on the project using MySQL, when learning the data quantity of the system and testing the service, often need to go over to a table two time points of data changes.Search

The usage of isnull,ifnull,nullif in MySQL is as follows:Usage of IsNull (expr):If expr is null, then the return value of IsNull () is 1, otherwise the return value is 0.Mysql> Select IsNull (+);0Mysql> Select IsNull (1/0);1The comparison of NULL

The purpose of this article is mainly by telling you what the query optimizer does for us, how we do it, to make the query optimizer optimize our SQL, and to enlighten us on how SQL statements are written to be more efficient. So what exactly is

Introduction: Principle and thought the Gtid master-slave replication mode is chosen here to ensure the correctness, health and compatibility of master-slave replication. Here are two servers, a, b each has MySQL instance 3310, two instances between

I used to look for data are using like later found that there are regular expressions in MySQL and feel better than like, let me share with you the MySQL regexp regular expression using a detailed, I hope this method is helpful to everyone.A regular

Constraints* The constraint is added to the column, to constrain the column!1. PRIMARY KEY constraint (unique identifier)Non-empty * * *Unique * * *Quoted * * * ** When a column of a table is designated as the primary key, the column cannot be empty

1/isamISAM is a well-defined and time-tested form of data management that, at design time, takes into account that the number of times the database is queried is much larger than the number of updates. As a result, ISAM performs read operations

1. Replication overview1.1. Replication-Resolved issuesData replication technology has some of the following features:(1) Data distribution(2) Load balancing (load Balancing)(3) Backup(4) High availability (Hi availability) and fault tolerance1.2.

Transferred from: http://www.cnblogs.com/ymy124/p/3718439.htmlMySQL's transactional support is not tied to the MySQL server itself, but is related to the storage engine 1. MyISAM: Transaction not supported, for read-only program lift high

Mysql performance optimization 2: mysql Performance Optimization Next, Mysql performance optimization 1Create an appropriate index To improve database performance, indexing is the best and inexpensive. There is no need to add memory, no need to

MySQL is used in Windows 64-bit system on the fourth day, and MySQL on the fourth day 1. Start/Close MySQL (1) Start the MySQL service:Net start mysql (2) Stop the MySQL service:Net stop mysql 2. log on to/out of MySQL First, let's take a look at

Mysql Event schedpent: Failed to open table mysql. event, mysqlopentable In fact, this error literally means you cannot open the mysql. event table, which is caused by permission issues. Mysql cannot run normally. The MySQL service cannot be started