MySQL

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

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

[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

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

When we enter data regardless of the case, for example: Enter AAA or AAA, AAA can query the same results, indicating that the query condition is not sensitive to case.Solution One:So I doubted the MySQL problem. Do an experiment: Use the client

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

DatetimeUsed when you need a value that contains both date and time information. MySQL retrieves and displays the datetime value in ' yyyy-mm-dd HH:MM:SS ' format, supported by ' 1000-01-01 00:00:00 ' to ' 9999-12-31 23:59:59 '. 8 bytes of

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

I. System database INFORMATION_SCHEMA: Virtual library, do not occupy disk space, storage is the database startup parameters, such as user table information, column information, permission information, character information, etc. MySQL:

Sometimes MySQL can not completely uninstall, this time must be removed by some means of the registry and some residual files, and then can be re-installed to succeed!1. Control Panel--"All Control Panel items--" program and function, uninstall

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

MySQL is a relational database management system developed by the Swedish MySQL AB company and is currently part of Oracle's product portfolio. MySQL is one of the most popular relational database management systems, and MySQL is the best RDBMS

Https://help.aliyun.com/knowledge_detail/41738.htmlMySQL full: Record pos locationMysqldump-h10.10.10.1-uadmin-p--master-data=2--single-transaction-r--events-q--all-databases > 2.sqlCat 2.sql |head-2222 Rows in the exported backup see the POS

Optimization of mysql query date by time, mysql Time query date For example, to query newly registered users yesterday, the statement is as follows: EXPLAINselect * from chess_user u where DATE_FORMAT (u. register_time, '% Y-% m-% D') = '2017-01-25

MySQL: database entry 4, mysql database entry 1. ViewCreate ViewCreate view name as query SQL statement;Drop view name;Alter view name as query SQL statement;2. triggers1. Insert an event triggerInsert into order_table (gid, much) VALUES (1, 3 ); --