MySQL Transaction ISOLATION level detailed

The SQL standard defines a Class 4 isolation level, which includes specific rules to define which changes within and outside the transaction are visible and which are not. Low-level isolation levels generally support higher concurrency processing

MySQL command line client uses commands

Original address: http://blog.csdn.net/jack2009win/article/details/6319261Feel good to write, copy it.Semicolons can't forget semicolons can't forget semicolons can't forgetThe important thing three times1. Enter the password: ******2.ues MySQL;

Mysql Numeric type conversion function

1. convert int to varchar often using concat function, such as concat (8, ' 0 ') to get string ' 80 'and menu_name like CONCAT (CONCAT ('% ', #{pd.keywords}), '% ')2. Convert varchar to int with cast (a as signed) a as varchar type stringSummary:

MySQL Error injection method collation

1, through floor critical error/* Database version */Sqlhttp://www.hackblog.cn/sql.php?id=1 and(select 1 from(select count(*),concat((select (select (select concat(0x7e,version(),0x7e))) from information_schema.tables limit 0,1),floor(rand(0)*2))x

Excel uses cell values to query the MySQL database and return data to the appropriate cells

Dim MyConn as ObjectPrivate Sub Connectdb ()Set myconn = CreateObject ("ADODB. Connection ")-----> Create Connection objectDim Str as Stringstr = "Driver={mysql ODBC 5.3 Unicode DRIVER};" & _----> Join statement ODBC Driver"Server=localhost;" & _----

MySQL Multi-range Read

MySQL version 5.6 provides a number of performance optimization features, one of which is multi-range read multi-range reading (MRR), its role for secondary/second index-based queries, reduce random io, and the random io into sequential io, improve

How to set up a firewall to enable MySQL to connect remotely

Because of the filtering function in the firewall, it is forbidden to enter the outside data message, can setIptables-i input-p tcp-d 192.168.18.9--dport 3306-j ACCEPTIptables-i output-p tcp-s 192.168.18.9--sport 3306-j ACCEPTNote that this rule

MySQL read-write separation

Why does MySQL have to master replication (read/write separation)?In layman's terms, the performance of a business system degrades if both the read and write of the database are operated on the same database server.In order to improve the

How to select the MySQL storage engine

One, the MySQL storage engineFull engine description or look at the Official document: http://dev.mysql.com/doc/refman/5.6/en/storage-engines.htmlHere are some of the main engines1. InnoDB Storage EngineInnoDB is the default transactional engine for

Mysql Insert Or Update Syntax example

Sometimes you will need to write an insert SQL, or update if the primary key exists, or insert if the primary key does not exist. This usage is provided in MySQL: ON DUPLICATE KEY UPDATE . Let's see how it's used! First the original data for

MySQL master-slave replication 1236 error

Today's monitor shows MySQL master-slave replication error, the information is as follows:Mysql> Show slave status\g;*************************** 1. Row *************************** slave_io_state:master_host:192.168.33.230

MySQL Service manual Installation method

Unzip the installationDownload and unzip the MySQL ZIP format installation package.Rename the extracted file to MySQL Server 5.6.Create the MySQL folder under the C:\Program files directory.Copy the folder MySQL Server 5.6 to the directory

MySQL Basic query

1. Conditionsusing the WHERE clause to filter the data in a table, the rows with the result of true appear in the result set, with the following syntax:select * FROM table name where condition;Example: SELECT * FROM students where id = 1;The where

Automatically back up MySQL database scripts

#!/bin/bash#auto Backup any one or all db#by Zhaoyanfeng#2017-8-15 11:17:54#definedAll_db= ' mysql-uroot-p123456-e "show databases;" | Grep-v Database | Xargs-n 1 'Mysql_user=rootMysql_passwd=

servlet connection to MySQL database

The code that writes the servlet today needs to be connected to the database, but due to the recent failure to write the database code, frequent errors, it is necessary to record, the next time this situation can be fixed in timeFirst steps required

Installation and uninstallation of the installation board MySQL

Originally downloaded an installed version of MySQL, the official network is written 32-bit, but can be used on 64-bit machine, the installation process of the other modules can basically install, but the most important MySQL server installation

The meaning of the columns in the show index from Tb_name command in MySQL

Show index from TABLE_NAMEThis command helps diagnose poorly performing queries, especially if the query uses an available index.The following describes the meaning of the result column that this command displays:| Table | Non_unique | Key_name |

MySQL row log format view Binlog SQL statements

Sometimes we need to use row as the Binlog log format, where the configuration file uses the binlog_format= row parameterSince then, when we look at the database Binlog content, we can not see the specific statement of additions and deletions, when

The difference between varchar and char in MySQL (Mind map collation)

Because MySQL has always been my weakness (in fact, I am very weak in all aspects), so recently in see MSYQL, just see the difference between varchar and char, so tidy up, easy to forget later.  0.0 pictures have explained everything, but the system

MySQL 8.0 replication Performance Improvement (translation), mysql8.0

MySQL 8.0 replication Performance Improvement (translation), mysql8.0What's New With MySQL Replication in MySQL 8.0? MySQL replication has been around for many years since its launch, and its stability and reliability are also steadily improved.

Total Pages: 3233 1 .... 1458 1459 1460 1461 1462 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.