The database operation is divided into three parts, namely, DDL (database, table operation) DML (data Delete and change) DQL (check)"DDL" CREATE | ALTER | DROPDatabase"CREATE DATABASE"CREATE datebase database name DEFAULT charracter SET UTF8 COLLATE
When we are using Java to connect to the database, we want to register the driver. Then get the connection object through the "Driver Manager" (Connection), when our program is accessed by many users, each time we create a Connection connection
First, MySQL multi-instance IntroductionOpen several different service ports (3306,33307,3308) on one server, run multiple MySQL service processes, share a set of MySQL installers, multi-instance MySQL is logically independent1, multi-instance
MyISAM and InnoDB explanationInnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application. The basic difference is that the MyISAM type does not support
First, the ViewA view is a virtual table (not a real one), which is essentially "getting a dynamic dataset from an SQL statement and naming it", which you can use as a table by simply using "name" to get a result set. Using views we can take out the
Original: https://jin-yang.github.io/post/mysql-group-commit.htmlGroup commit is to optimize the brush disk problem when writing logs, from initially supporting only the InnoDB Redo log group submission, to the 5.6 official version support redo log
2017-10-30Next article (use Java IO package for file read and write operations here, I'll summarize how to use JDBC to connect to the MySQL database and perform data query operations . SceneUse the JDBC connection database to query the data, return
View MySQL Execution planUse Navicat to view the MySQL execution plan:Open Profile Analysis tool:Check to see if it takes effect: Show variable like '%profil% ';View process: Show Processlist;Select database: Use Db_jiakao;Type of all analysis: Show
Second, design skillsprogramming habits vary from person to person, here only to provide some experience, can be consulted. 1. Use include to modularize your program codeThe include function basically says, "It's like reading another file (HTML or
Initial understanding of MySQL Gap lockBeginning to know the gap of MySQL, think this design is unique, and other database practices are not the same, so tidy up a simple memo (although about the gap lock, the relevant information is many)1. What is
One or two binary compilation install MySQLCENTOS6, 7 are basically the same, but a few steps are also marked out, the steps are as follows: ① Download the installation package and import it into CentOS for decompression. 650) this.width=650; "src=
MySQL cmd Common command mysql cmd Common command has the following command: Put the Mysql.exe in the bin directory under the MySQL directory under C:\WINDOWS, you can execute the following commandConnection: Mysql-h host address-u user name-P user
Recently, to build a local MySQL environment, the preparation and installation process are as follows:1. Software Environment:CentOS 7Mysql 5.62. Linux Environment installation Method comparison:
Installation method
Advantages
Column Properties (constraints)1: Whether NULL is allowed (NOT NULL)--not null is not allowed to be emptyCREATE TABLE T_1 (A tinyint (3) Zerofill NOT NULL,b tinyint (3));Example: INSERT into t_1 values (18,29);Example: INSERT into t_1 values (null,12
A lot of information on the Internet, and finally found a viable, share the following:Database size query:Select Concat (Round (sum (data_length/1024/1024), 2), ' M ') from INFORMATION_SCHEMA. TABLES where table_schema= ' database name ';Table size
ext.: http://www.cnblogs.com/sns007/p/5790838.html1, split horizontally:Example: QQ's login form. If QQ users have 10 billion, if there is only one table, each user log in when the database to find from the 10 billion, will be very slow and slow. If
This paper introduces the tuning method of MySQL, including slow log query analysis and explain query analysis SQL execution plan1. mysql optimization1, slow log query analysisYou first need to make some settings for the slow log, as follows:SHOW
Mysql limit usage (recommended), mysqllimit
SELECT * FROM table name limit m, n; SELECT * FROM table LIMIT [offset,] rows;
1. m indicates Retrieving from m + 1 record row, and n indicates retrieving n data records. (M can be set to 0)
For
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