MySQL

One, MySQL two kinds of login methodsIP-based sign-in modeMysql-uroot-proot-h 127.0.0.1# -uroot user name root## - H 127.0.0.1 IP : 127.0.0.1. Do not fill default is localhostSocket-based sign-in modeMysql-uroot-proot-s/tmp/mysql.lockIi. user

Scene:When writing data in bulk, MySQL server has gone awayWorkaround:Set the Max_allowed_packet parameter a little larger in My.ini　　　Show global variables like ' max_allowed_packet ';　　The above workaround does not solve the problem, other reasons

Connect MySQL User: mysql-u root-p Enter passwordCreate DATABASE: "Database name"Copy data: Navicat Transfer data functionProblems that occur during the process:1, open the table, reported 1018,can ' t read dir of '. xxxx ' (errno:13)

#1, view table capacity spaceSELECTTable_schema,table_name,table_rows,ROUND(Data_length/1024x768/1024x768/1024x768) as 'data_size (G)',ROUND(Index_length/1024x768/1024x768/1024x768) as 'index_size (G)',ROUND(Data_free/1024x768/1024x768/1024x768) as '

CentOS system has an abnormal shutdown after the start of MySQL has been error#/etc/init.d/mysqld startStarting MySQL. error! The server quit without updating PID file (/data/mysql/linux-01.pid).View the error log as follows[Email protected] ~]#

The project was originally an Oracle driver + Druid data source configuration and is now being modified to MYSQL+DRUID data source configurationWhen you start the project, report: Java.sql.SQLException:com.mysql.jdbc.DriverThe reason for the error

First, configure the MHA working environment192.168.2.130 Machine Operation:1.1. Create the working directory of the MHA and create the relevant configuration file(There is a sample configuration file in the directory after the package decompression)

If you need to add a MySQL user, you only need to add new users to the user table in the MySQL database.The following is an instance of adding a user named Qi, a password python , and an authorized user to SELECT , INSERT , UPDATE , DELETE , CREATE ,

Common components of a relational databaseDatabases: DatabaseTables: TableRow: RowColumns: ColumnIndexes: IndexTrying to: viewUsers: UserPermissions: Privilege 存储过程：procedure 存储函数：function 触发器：

Note The order of Where,group by, having,order by, and limit.The primary table is the table that is bound, the child table is the table with the foreign key added, note that you can add a foreign key when creating the table, or you can add a foreign

The role of the database　　The popular database　　Basic concepts of databasesObjectively, the things that can be described are entities .　　A table is a collection of data , a database is a collection of tables , and a relationship is part of a

1. Optimized query for query cacheMost MySQL servers have query caching turned on, which is one of the most effective ways to improve performance, and this is handled by the MySQL database engine.Some queries do not use caching, such as Curdate (),

I recently encountered a problem with the project is that the database orders need to check their order status regularly, if the time of the Endtime field order status or 2, the order status is modified to 4Find a similar solution on the web.The key

Create a stored procedureCREATE PROCEDURE myprocess ()BeginEndTo avoid a semicolon (";") in the stored procedure In the concluding sentence, we use a delimiter to determine whether the command is over.So we can use the $ sign as a closing (or

This article does not involve complex underlying data structure, through explain interpretation of SQL, and according to the possible situation, to do the specific optimization, so that millions, TENS data Table Association query first page results

1. Download the appropriate version of the website https://dev.mysql.com/downloads/mysql/5.6.html#downloads2. Extracting filestar -zxvf mysql-5.6. -LINUX-GLIBC2. A3. Copy the extracted MySQL files to the system local software directoryCP mysql-5.6.

Master-Slave replication principle:When Master receives a write request, the complete process of the current completion event is logged to the Binlog log, notifying the slave event update, at which time the IO thread is generated from the server and

Create a tableincrease, delete, change and check the data in the tableCheckRight-click the table you just created-choose to view the top 1000 dataIncrease, changeThe table must have a primary key to add data, and the primary key cannot be duplicated1

I. Introduction to MySQL PrivilegesThe simple understanding of MySQL permissions is that MySQL allows you to do what you do best, and you can't cross the border. For example, if you are only allowed to perform a select operation, you cannot perform

Make a backup to another tableSELECT * Into Persons_backup from Persons this way in MySQL run will report undeclared variable errorMySQL does not support, replaceCREATE TABLE Persons_backup (select *from persons)Copy a field from one table to