MySQL

Lower_case_table_names parameter Details:Where 0: Case sensitive, 1: Case insensitiveMySQL under Linux database name, table name, column name, alias casing rules are like this:1, database name and table name are strictly case-sensitive;2, the table

"MySQL must know" notes-partComments:Start to organize notes, record their own reading process of doubt and focus, later found that the record does not have much meaning, it is better to go directly to the original book, so give up.So the note is

The problem is usually caused by multiple table or cross-Library table queries because the character set of the two tables is not the same, so why are the character sets of the two tables different? This is due to the fact that the architect or

not much to say directly on the statementSELECTa.ID,A.thumbnail,A. NAME,A.marketprice,A.memberprice,A.personname,A. STATUS,A.recieveorderdate,A.tracknumber,A.contact,A.reportsenddate, B. Tracknumber, A. Reportdownloadpath

Today encountered an exception, in the execution of a query function, the background will be error, did not return the query results.Linux server is generally the MySQL configuration file problems (the same data in the local error), MySQL Restart

A long time to display when starting mysqldTimeout error occurred trying to start MySQL Daemon.Display when terminal enters MySQLERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)Later found to

Mysqlslap is a stress test tool from Mysql that can simulate a large number of clients operating the database at the same time, through the results of information to understand the performance status of the databaseA major work scenario for

The previous blog said that using LOGSTASH-INPUT-JDBC to synchronize MySQL data to es (http://www.cnblogs.com/jstarseven/p/7704893.html), but there is a problem, That is, if I do not need logstash automatically to the MySQL data provided by the

One or two binary compilation install MySQLCENTOS6, 7 are basically the same, but a few steps are also marked out, the steps are as follows: ① Download the installation package and import it into CentOS for decompression. 650) this.width=650; "src=

To stop the MARIADB service:systemctl stop mariadbsudo mysqld_safe --skip-grant-tables --skip-networking & Login directly with root, no password required:mysql -u root To reset your password:mysql> use mysql; mysql> update user set password=

The system version I am using is: sles12-sp2Using Python to connect to MySQL database requires installing the Mysql-python module;1. First install PIP:Download get-pipe.py from the official Python website and execute this script to install (or

I. Overview1, Version supportShow profiles is added after 5.0.37, to use this feature, make sure the version is after 5.0.37.To view the database version:Select version ();2. View turn on off and default settings observation count like ' profiling% '

Since importing Excel data with Dbeaver Import is unsuccessful, the following methods are used:1 Excel Save as CSV file--Open with Notepad--Save as TXT file, set encoding UTF8;2 MySQL new table Data_analyst3 Load Data local infile '

Data table for InnoDB engineThe frm file for the datasheet exists in the Data folder, but these tables are not visible in phpMyAdmin and are then restored by importing the SQL file1, directly import the original data table SQL file, the original frm

Database is the core of all application systems, so to ensure the stable, efficient and safe operation of the database is the most important work of all enterprises. Once a database system fails to provide services, it may cause the entire system to

One of the most incredible MySQL deadlock analysis Deadlock problem Background Do MySQL code in-depth analysis also some years, plus their own 10 years or so of database core research and development experience, since the mysql/innodb

Original: xtrabackup backup restore MySQL DatabaseMysqldump Backup In view of some of its own characteristics (lock table, essentially back up the insert script or text, does not support differential backup), is not suitable for high-real-time

MYSQL subquery and nested query optimization instance parsing, mysql nested instance Parsing Query the highest score of the game history score of 100 SQL code SELECT ps.* FROM cdb_playsgame ps WHERE ps.credits=(select MAX(credits) FROM

Implementation Analysis of MySQL statement locking, mysql statement implementation Abstract: Analysis of Two SQL statement locks in MySQL Check the lock applied to the SQL statement under explain. SLQ1：select * from t1 where id = 10;SQL2：delete from

MySQL _ date function summary and mysql function Summary If it is reprinted, please indicate the source of the blog: www.cnblogs.com/xinysu/. The copyright belongs to xiaoradish in the blog garden. Thank you for your support! For MySQL date and