MySQL

The content of this article: What is a character set? What is a proofing set? Viewing character sets and proofing sets Set up character sets and proofing sets Problems with Chinese data in MySQL Starting Date: 2018-04-19

MySQL data type Date type DateThe date data type is responsible for storing day information (1000-01-01 to 9999-12-31)You can use numeric and string insertions (20180809 or "2018-08-09") to use separators other than numbers or

MySQL single-column index is what we often see in MySQL database, the difference between MySQL single-column index and composite index may be a lot of people do not know very well, the following for you to analyze the main differences, for your

This article tells the four characteristics (ACID) of transactions in the database, and will explain the isolation level of the transaction in detail.If a database claims to support transactional operations, then the database must have the following

IntroductionUsually with Linux, I do not have a hard time regretting that Linux did not study well. Install some software with some environment is very afraid, thanks to the Docker. Docker is an application container engine that manages a lot of

1. Some functions , such as lower (lowercase), upper (uppercase), Initcap (capital letter). It is particularly understood that sum (a) is the sum of the computed A, and count (a) is the number of records that contain a, calculated as the total

TitleError adding permissions to user with Navicat remote connection databaseConnect to MySQLMysql-uroot-p;use MySQL;Change permissionsUse grant all privileges to change the user's remote permissions for some librariesGrant all privileges the on

Sometimes data operations are required, and data is updated if there is data, and no data is inserted. The previous practice is to query, and then based on the query results to judge, to perform the INSERT or update operationThere is actually an on

Today, after launching the database for the new line of business, the error[Email protected]:/usr/local/mysql/bin#./mysqlERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock ' (2)In this record, I

MySQL Database installation 1 yum/rpm mode installationNote: The yum/rpm way to install MySQL is suitable for all MySQL software PRODUCT families.(1) RPM package installation MySQLWe have to install the Mysql-server and mysql.client packages, the

I. Why a backup is requiredIn a real-world production environment, it is a mistake to delete the operation, the hardware damage will result in the data is not available, this time we need to backup to achieve disaster recovery. Hardware-level

Learn a little programming every day PDF ebook free download: Http://www.shitanlife.com/codeOn the MySQL remote connection problem, everyone in the company's work, often encounter MySQL database stored on a person's computer, you want to connect to

17.1 MySQL Master-slave introduction18.The main application scenario1. Data backup2. Use as a read library to reduce the pressure on the main library17.2 preparatory workWill master and slave both start the MySQL service, linux-01 as the main

Excerpt from: HTTP://BLOG.CHINAUNIX.NET/UID-25063573-ID-3032578.HTML1. Index functionIn addition to the ordered lookups mentioned above, the database uses a variety of fast location techniques to greatly improve the query efficiency. In particular,

Write in frontYesterday went to Tsing Lung Gorge to play a day, tired and dog-like. But fortunately, finally counted on the top of the mountain, but also count to Beijing after the conquest of the third mountain. Here also nagging, do the

　　Establishing SSL connection without server ' s identity verification is not recommended.This error occurs because of the MySQL version problem, different MySQL for SSL usage is not the same, try not to use SSL connection. Here's how to do it.URLs

1.MySQL Performance Tuning IdeasWhat if a server has a long time load too high/ periodic load is too large , or occasionally stuck how to handle ?is it a cyclical change or an occasional problem ? is a problem with overall server performance , or

I. Overview of MYSQL/MARIADBMySQL was developed by my SQL company in 1995, the relational database management software, MySQL development several times after the version replacement, the latest is 5.7ga/8.0dmr,my SQL company itself has also

[Client]Port = 3306Socket =/tmp/mysql.sock[Mysqld]Port = 3306Socket =/tmp/mysql.sockBasedir =/usr/local/mysqlDataDir =/data/mysqlPid-file =/data/mysql/mysql.piduser = MySQLBind-address = 0.0.0.0Server-id = 1 #表示是本机的序号为1, which is generally the

The reason is that the permission is not opened1. The command line enters MySQL (assuming root user's password is also root) Mysql–uroot–proot 2. Use MySQL database using MySQL; 3. Grant all privileges on * * to ' root ' @ '% ' identified by ' root '