MySQL

MySQL database in the penetration process can use more features, in addition to reading data , you can also read and write to the file (but only if the permissions are sufficient)Summarized under MySQL read file method in different versions roughly

Knowledge Points:Use MySQL to search for a resident's data by age (number of inhabitants of all ages)1. For example: Inquiry resident (resident chart), according to the age group, the number of statisticsThe 2.mysql statement is as follows:Select

method One: Change the my.cnf configuration fileVI/USR/LOCAL/KKMAIL/CONFIG/MYSQL/MY.CNF cancels the following two lines of comment and then restarts mysql#general_log = 1#general_log_file =/tmp/kkmail_ Mysql.log# Set general Log Save path# It seems

MySQL Database Settings master-Slave synchronizationFeatures of Master-slave synchronization:of logicof asynchronousThe role of master-slave synchronization1. Backup2. Read and write separationSteps for master-slave synchronization Prepare

Reference: http://dinglin.iteye.com/blog/1681332Limit for the length of a single-column index(5.6 Inside the default cannot exceed 767bytes,5.7 not more than 3072bytes):The cause is 256x3-1=767. This 3 is the maximum character space (UTF8). However,

Welcome to the big Data and AI technical articles released by the public number: Qing Research Academy, where you can learn the night white (author's pen name) carefully organized notes, let us make a little progress every day, so that excellent

MySQL Master-slave Introduction:MySQL master-slave is also called replication, AB replication. Simply speaking is a and b two machines from the back, write the data on a, the other B will follow the writing data, both data real-time

12.1 Lnmp Architecture Introduction13.12.2 MySQL Installation[[Email protected] ~]# service MySQL stopRedirecting To/bin/systemctl Stop Mysql.service[[email protected] ~]# ps-aux |grep MySQLRoot 1064 0.0 0.0 112676 956 pts/0 s+ 23:07 0:00

MySQL data typeIn MySQL, there are three main types: text, numbers, and date/time types.Text Type: Data Type Description CHAR (size) Holds a fixed-length string (which can contain letters, numbers, and special

[Mysqld]Datadir=/usr/local//mysql/data #数据存放位置Socket=/var/lib/mysql/mysql.sockUser=mysqlLower_case_table_names = 1 #是否忽略大小写 with a value of 1 ignoring case# Disabling Symbolic-links is recommended to prevent assorted security

First, create a regular user and authorize 1, create a user and authorize[[email protected] ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.6.36 MySQL

ObjectiveIn the previous blog, there have been several written about MySQL in Linux under the building of the tutorial, may later will be written again, but do not want to repeat in writing, so I would like to separate this out, a separate blog, and

MysqlIntroduction to Database logging1th Chapter BinlogLog1.1 BinlogLog IntroductionMySQL binlog log function is used to record mysql internal additions and deletions to the MySQL database has updated content records (changes to the database),

For mysql5.5 above.Windows platform:\s View the character encoding of the server, Db, Client, Conn, and the inconsistency should be changed to consistentUnified character Encoding:New My.ini in MySQL installation directory, add content, can refer to

In the previous article mainly organized the Golang connection MySQL and some basic operations, and carried out a general introduction, this article on the deletion and modification of the detailed collationReading dataIn the previous article to

Example: SQL fuzzy query, using the like comparison keyword, plus the wildcard characters in SQL, please refer to the following:1, like' mc% 'All strings (such as McBadden) that begin with the letter Mc will be searched.2, like'%iNger 'All strings

This article refers to how MySQL allocates internal memory, and how to properly set memory allocations and how to monitor memory usageOfficial documentsMySQL is assigned to 512MB RAM by default at startup and can be set by setting the relevant

Export of data:SELECT * FROM mytable into outfile ' D:/mytable.xls ';You can find the Mytable.xls file under the packing directory.Import of data:Import with exported table Mytable.xls: Input command: Load data infile ' d:/mytable.xls ' into table

Translation: SET Variable (submitted to the MariaDB official Manual), variablemariadb This article is the official mariadb Manual: the translation of SET Variable. Original article: https://mariadb.com/kb/en/set-variable/Https://mariadb.com/kb/zh-cn/

Translation: last_value () function (submitted to the MariaDB official Manual), last_valuemariadb This article is the translation of LAST_VALUE () in mariadb's official manual. Original article: