MySQL

1) READ UNCOMMITTED: Read data that has not yet been committed: no problem is solved2) Read Committed: Reads the data that has been submitted: can resolve dirty read----Oracle Default3) Repeatable READ: Reread read: Can resolve dirty read and

1. How does MySQL implement non-interactive queries?Mysql-h 172.16.136.9-p6515-u user-ppasswd db_name-e ' select * from game_flow_balance where ActivityID = "YWyY1oi2" an D (status = "2" or status = "4"); 'Note:-E non-interactive single quotation

Starting with version 5.6, you can use the Mysqlbinlog command to back up logs from a remote machine to a local directory, making it easier and faster to implement a Binlog server.Environment Description: 192.168.56.100 is a backup server, 192.168.56

1. Back up the MySQL database on the server [[email protected] ] # mysqldump -h localhost -u root -proot --databases Surpass --routines > /home/SQLBackup/Surpassme_20180801.sql 2. View the SQL script after backup [[email protected]

MySQL Common syntax:1. Using MySQL:(1) Understanding databases and tables:SHOW databases;Analysis: Returns a list of available databases.SHOW tables;Parse: Returns the table in the current selection library.(2) Select database:use databases;Analysis:

Server-side command SQL In the database system, SQL statements are case-insensitive (uppercase is recommended)? SQL statements can be written in one or more lines, with ";" End? Keywords cannot span multiple lines or shorthand? Use spaces

Let's start by talking about the primary key and the unique index: a table of one database has only one primary key , and a primary key cannot repeat a unique index: a single table on a database can have multiple , just the value on the unique index

To use Django for project development recently, you need to use the Mysql-python module.In the local installation of the environment when the error occurred,unable to find Vcvarsall.batFind a lot of information on the Internet, found that the window

First, the successful index optimization 1. The table data is as follows: 2. The query statement is as follows: Explain select ID, age, level from employee where Dpid = 1 and age = of order BY Extra:using where; Using Filesort

Execute a stored procedure using PythonExecute a stored procedure using Python [Part 2]: 1. Execute the stored procedure to get the result set of the stored procedure2. Set the return value to the @_ stored procedure name _ Number = #!

For established index (surname, first name, data)5.1, the index of the query type is valid1, full value matching: can find the surname + named Allen, the date of birth is 1990-11-05 person;2. The leftmost prefix matches: You can find the person

1. First download MySQL The version I selected is 5.7.19 based on the 64-bit Windows operating system. MySQL Portal: https://dev.mysql.com/downloads/mysql/There are different operating systems installed in the installation package you need to

#!/bin/bashpkill-9 MySQLDate +%y-%m-%d-%h-%m#卸载系统自带的Mysql/BIN/RPM-E $ (/bin/rpm-qa | grep mysql|xargs)--nodeps/BIN/RPM-E $ (/bin/rpm-qa | grep mariadb|xargs)--nodeps/bin/rm-f/etc/my.cnf#安装编译代码需要的包/usr/bin/yum-y install make wget gcc-c++ cmake

I. List of permissionsSelect_priv. Determines whether the user can select data through the Select command.Insert_priv. Determines whether the user can insert data through the Insert command.Update_priv. Determines whether the user can modify

The traditional operations in relational data operations--and (UNION), Cartesian product (Cartesian product), connection (join).1. and (UNION)" and " is to merge tables with the same number of fields and the same field type.Number of records merged =

1.WITH ROLLUP: Statistical data is performed on the basis of the Group field.Example: First group on the Name field, then some field statistics on the basis of the grouping, the table structure is as follows:CREATE TABLE' Test ' (' Id ')int( One)

On the MySQL server, view the/etc/my.cnf fileSet up:log-queries-not-using-indexes=onlong_query_time=0.03log-slow-queries=/var/log/mysql/mysqld.queries-slow.log 1 2 3 Log-queries-not-using-indexes=on open an SQL statement record

1. Role of the index:(1) Improve query speed(2) Improve the sorting speed(3) Increase the speed of group statistics2. Parsing of the index:Explain select * from T4 where a1=3 and A2>4 and a3= 53. Clustered index and non-clustered indexNon-clustered

One, why use trigger 1. What is a trigger Triggers are one of the MySQL database objects that need to be declared, executed, etc., the execution of the trigger is not called by the program, nor is it started manually, but is triggered and

Since the work of the IT Internet has been a few years ago, I was really lazy, never write blog, never summed up the work experience, led to their own technical upgrading is very slow, growth is very slow, serious began to write blog is from the