MySQL

Server system Variables (System variable)The MySQL system variable (systems variables) refers to the various system variables of the MySQL instance, which are actually some system parameters that are used to initialize or set the database to occupy

What is a transaction?A transaction consists of one or more SQL statements, and if all statements execute successfully then the modification will take effect, such as a SQL statement will sell +1, the next +1, and if the second fails, then sales

Scenario: MySQL adds a parent_id column to the table and sets it to not NULL, saving the Times wrong invalid use of NULL value.Cause of error: Because the parent_id of the existing data column is null, the setting conflicts with not NULL.Workaround:

ObjectiveInstalling MySQL database and navicat is not a difficult task, the key is how to make them work spent my whole day, and finally get it done. Encountered a variety of problems, the Internet to read a large number of blogs, found that many

INDEXBecauseperformance, Smart resultsFor many reasons, when searching for text, Full-Text search one is better than the wildcard wildcards regular expression, which indexes the specified column to quickly locate the corresponding row, andSmart

MySQL comes with a pressure test tool called Mysqlslap, or a good simulation. Let me give you an example. Mysqlslap is an official MySQL-provided stress testing tool starting with version 5.1.4. Perform stress testing by simulating multiple

Create procedurejack_count_cur_dual ()BEGINDECLARETb_nameVARCHAR( -);DECLAREDoneint DEFAULT 0;DECLAREMycurCURSOR for SELECTtable_name fromtt_countrows;DECLARE CONTINUEHANDLER for notFOUNDSetDone= 1;DROP TABLE IF EXISTStt_countrows; #删除, create a

The Nineth chapter searches with regular expressionsThis chapter will learn how to use regular expressions within the MySQL WHERE clause to better control data filtering.9.1 Introduction to Regular expressionsThe filtering examples in the first two

MySQL high-availability cluster skill target Familiar with MMM high-availability architecture Familiarity with MHA high-availability architectures Learn to configure MMM high availability Learn to configure MHA high availability

In the daily maintenance of the database, the developers are the most headache, many times due to the SQL statement written by the problem caused the server problems, resulting in resource exhaustion. The most dangerous operation is to forget the

A BackgroundLast year, a MySQL trace replay test, due to the performance schema itself to collect sample length and other limitations, the actual playback of the success rate is relatively low.Recently found an open source tool, based on tcpcopy

Yesterday went to an interview, the company is not too big, is a Japanese-funded enterprises, in the domestic have several branches, the interviewer asked the basic operation and performance optimization of MySQL, said a lot, it is more relaxed, but

Objective Unlike most databases, MySQL has the concept of a storage engine that can choose the optimal storage engine for different storage requirements. 1. MySQL Storage Engine Overview Plug-in storage engine is one of the

Because the MySQL version is too high to create a connection, the following report appearsWorkaround: Add &usessl=true on the MySQL connectionAs follows: Jdbc:mysql:///:3366:test?useunicode=true&characterencoding=utf-8&usessl=trueSSL is an

Or a cat's eye movie, for example, this time using Pyquery library to crawl 1. Simple demo, see How to extract information using pyquery, and combine the extracted data#Coding:utf-8#AUTHOR:HMKImportRequests fromPyqueryImportPyquery as

In ubuntu, there are at least two methods to convert the MDB file to MySQL:1. Use knoda for conversionThis is KDE.ProgramIs a graphical interface, which is very simple. Sudo aptitude install knoda libhk-classes-MDB After installation, MS

Various joins in MySQL 1. Cartesian Product (cross join) In MySQL, you can think of cross join or omit cross as join, or use ',' For example Select * From Table1 cross join Table2 Select * From Table1 join Table2 Select * From Table1,

Conversion from MySQL code Note: decimal. c Bytes ------------------------------------------------------------------------------------------------------------ *Convert decimal to its binary fixed-length RepresentationTwo representations of the same

MySQL batch Import and Export Excel and TXT data 1. Excel files 1.1 export data to an Excel file select * into outfile "C:\\Users\\Administrator\\Desktop\\data_out.xls"from bi_admin; Note that the "\" contained in the storage path needs to be

To store the address resolution information associated with the address, we need to design an appropriate data architecture. In this example, we want to display restaurants or bars on map mashups. For such sites, a typical database table should