MySQL

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

Client login to MySQL server via Navicat error: 1045-access denied by user ' Zabbix '@192.168.0.107 using Passwod:yesSolution:Server-side login MySQL:Use MySQL;Check the Select User,host from user first;The client's IP is not found in the

13.1 Setting Change root password[Email protected] init.d]# echo $PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin[Email protected] init.d]# path= $PATH:/usr/local/mysql/bin[Email protected] init.d]# Vim/etc/profile[Email protected]

You old iron, this week Lao Zhang's "MySQL King Promotion Road" a book finally published, now can be pre-order!Pre-order link address: Lao Zhang's database micro-storeAfter a year of preparation time, it is ten years to sharpen a sword, all the

　　1 in Java only the date type, so that the data stored in the MySQL problem, the foreground submitted data, such as 2018-03-20 17:30:59, background with date accepted, because date only accurate to day, so the default receive time is 2016-10-10 00:0

Lead Practical experience from the frontline There's a bloody lesson behind every military rule. Do not be gorgeous, as long as practical If there's one that benefits you, you'll be comforting. Primarily for database

1.Mysql Dual Master and multi-master synchronous combat, mainly fromUse the main premise:A. Table's primary key auto-increment (M library id1,3,5;m library ID 2,4,6)Preparation: Two machines, here with multiple examples to explainFirst set:ip:192.168

MySQL use index () optimization queryForce Index/ignore The syntax of INDEX:SELECT * * * from TABLE [{use| ignore| Force} INDEX (key_list)] WHERE ...Use INDEXAfter the table name in your query statement, add use index to provide the index column you

In MySQL Ops, the research colleague wants to compare the data on the next two different instances and find out the difference, how do you want to compare each field in addition to the primary key?In the first scenario, the write program extracts

Day02One, MySQL indexSecond, MySQL storage engine+++++++++++++++++++++++++++++++++++One, MySQL index1.1 Index Description: Equivalent to "book directory"Page 50001~200 directory informationPhonetic sortingRadical sortStroke sort201~5000 body1.2

MySQL master-slave backup Configuration instanceScene:1, the primary server 192.168.0.225, from the server 192.168.0.226. Where the data is already available on the master server.2, the MySQL version on the master and slave server and the same

Note: python2.x with Mysql-python, from python3.x onwards, changed to MysqlclientThe MySQL driver for Windows installation Python is so easy:pip install mysql-pythonBut it's no surprise that something went wrong:_mysql.c(42) : fatal error C1083:

Most of the internet is MySQL terminal input in Chinese garbled, and then change the character set of MySQL server operation, but the lack of MySQL terminal cannot input Chinese, copy the SQL statement copied to MySQL terminal Chinese cannot display:

1. Network detection1) Ping the host can;2) Telnet host 3306 port can not;Telnet host 22 port can be;The description is not related to the native network;2. Port detection1) netstat-ntpl |grep 3306TCP 0 0::: 3306:::* LISTEN-2) Netstat-ntpl |grep

When the server is put on the LAN for testing, the database access speed is still very fast. However, when the server is placed outside the network, the database access speed becomes very slow.Later found the solution on the Internet, my.cnf inside

PHP has removed some of the functions, of which the scary ones are two:1. Regular functions of the Ereg_* series2. Database connection functions for the Mysql_* seriesPHP7 full removal of MySQL extension support, the original Mysql_* series

SELECT Group_concat (REPLACE (Path, '/', ', ')) as path from Department b WHERE Department_type = 1Execution Result:Sql:Select DISTINCT Substring_index (Substring_index (A.path, ', ', b.help_topic_id + 1), ', ', -1) from (select Group_ CONCAT

1. Modify the root user password to remove the empty passwordThe default installed MySQL root user is a blank password, for security purposes, must be modified as a strong password, so-called strong password, at least 8 bits, composed of letters,

Liu's 91st blog posts and 91st blog posts Starting today and finishing the work in the evening, I have to submit an interim report on March 13, 2nd day of next month. The time is not long and I may not be able to write much code in a few days. I

Translation: Value assignment operator (: =) (submitted to the MariaDB official Manual), operator mariadb This article is a translation of the value assignment operator (: =) in the mariadb official manual. Original article: