MySQL

First look at the SQL statement for the query:Select ID, t1,t2 from t_table where ID in (232922924);The above query statements cause the database to run high threads, resulting in a slow page response. So where do you need to optimize query

First log in to MySQL.  First set the password:Mysql> Set password for user name @localhost = password (' new password '); Authorizing a user Mysql> Grant all privileges on * * to ' user ' @ '% ' identified by ' password ' with GRANT

The main purpose of the design index is to help us get the results of the query quickly, whereas a like query starting with% cannot use the B-tree index.Considering that the InnoDB tables are clustered tables (similar to the Index organization table

Test environment centos7.3+mysql5.7A table using the InnoDB engine, the table name Innodb_testThe other table uses the MyISAM engine, and the table name Innodb_testIn the event of a transactional operation, see what happens.Table structure same as

mysql-5.7.21 start error, Permanent solutionchmod +x/etc/rc.d/rc.local#往里面写入两条命令, which means to automatically create mysqld and modify owner permissions for bootEhco "Mkdir-p/var/run/mysqldChown-r

When we create a table field with Jeplus, we will be prompted with an error if our total length exceeds a certain limit, so when we use jeplus When you create a table field, keep in mind that the length of the type that we create table fields must

bidirectional Mutual Master from step:12 machines Add a cluster machine access to the account given replication slave permissionsmysql> grant replication Slave on * * to ' rep ' @ ' 172.16.1.% ' identified by ' 1234566 ';22 Machine parameter

Select Group_concat (column_name Separator ', ') as column_name from INFORMATION_SCHEMA. COLUMNS WHERE table_name = ' t_tk_question_info ' and table_schema = ' dsideal_db ';Select Group_concat (column_name Separator ', ') as column_name from

The newly installed CentOS 6.9 virtual machineModifying the Yum server sourcecd/etc/yum.repos.d/Rename Repo repo.bak_$ (date +%f) *Ali's Yum Library Https://opsx.alibaba.com/mirror Open Point HelpCurl-o/etc/yum.repos.d/centos-base.repo

single-table query 1, query all:SELECT * from table name;2. Query the selected field data:Select field name from table name;3, query the data under the specified conditions:Select field name from table name where condition (example id>3);4, after

1. Check if the MySQL server is started-| grep mysqldHow to display the following, proof has been startedlocalhost:~ mhx$ Ps-ef | grep mysqld0 1053 1 0 9:59 am ttys000 0:00.03/bin/sh/usr/local/mysql/bin/mysqld_safe--datadir=/usr/local/mysql/data--pi

This lesson first experiences the basic syntax of MySQL. Action folder (library) increaseCreate Database db1 charset UTF8;Check# View the currently created database Show Create database db1; # View all databases show databases;ChangeALTER DATABASE

With SQL statements, delete duplicates only keep oneIn thousands of records, there are some same records, how can you use SQL statements, delete duplicates1, look for redundant records in the table, duplicate records are based on a single field

File Preparation:Django ProjectMYSLQ InstallationShutting down the firewallDrag and drop to CentOS with Xshell.installation files: Installing python3.6 (3.7 problematic)SH install_py36.sh　　Shutting down the firewallSH stop_firewall.shInstall MySQLSH

Querying existing databases: show databases;Operations on the database:1. Delete database: Run drop database + name;2. Add Database: Run CREATE DATABASE + name;Operations on a table:First you have to open the database of the table you want to

In the development in order to make development more convenient, in the local configuration environment, you want to have direct access to the MySQL database on the server, more convenient management database,You need to remotely connect to the

1 General IndexALTER TABLE ADD INDEX index_name ('column')2 PRIMARY Key indexALTER TABLE ADD PRIMARY KEY ('column3 Unique IndexesALTER TABLE ADD UNIQUE ('columnA unique index here guarantees uniqueness of the data record, and in many cases, creating

INSERT into ' material ' (' id ', ' file_url ')SELECT id,ekm. ' File_url 'From ' extmaterial ' as EKMLeft JOIN (SELECT ' file_url ' from ' material ' WHERE ' id ' = ID) as PM on PM. ' File_url ' = EKM. ' File_url 'WHERE EKM. ' ext_id ' = Extid and

1 MySQL master-slave synchronization, prepare 2 servers, already installed MySQLMaster: mysql1:192.168.12.101From: mysql2:192.168.12.1022 master-Slave synchronization requires the Binl-og log to be turned on and the library from MYSQL2 needs to be

First, the environment1 6.5 2 5.6. - 3 Host A:192.168. 1.1 (Master) 4 slave B:192.168. 1.2 (Slave) 5 slave B:192.168. 1.3 (Slave)Second, the basic Environment configurationMySQL is accessed via port 3306, so make sure the firewall is on for Port 330