Introduction to a storage engineThe storage engine is a table type, and MySQL has different processing mechanisms depending on the table typeSee: http://www.cnblogs.com/6324TV/p/8481061.htmlTwo table IntroductionTable is equivalent to a file, a
First-level caching:Also known as local cache, sqlsession level cache. The first-level cache is always on, and the data that is queried during the same session as the database is placed in the local cache.If you need to get the same data, take it
A system database
Two database operations
Three-Name specification
Four user rights
Five. Change the password
Six forgot Password
Seven Chinese garbled problem
I. System database
INFORMATION_SCHEMA: Virtual
First, the problem descriptionMySQL v 5.0.91[Email protected] bin]#./mysqlbinlog/tmp/mysql-bin.000015/!40019 SET @ @session. max_insert_delayed_threads=0/;/!50003 SET @[email protected] @COMPLETION_TYPE, completion_type=0/;DELIMITER/!/;#at 4#180227 1
1. Copy the table structure into the new table. (Data in the table is not copied)CREATE table new table like old table;OrCREATE Table New Table SELECT * from old table WHERE 1=2; 2. Copy the data into the new table. (The new table will not have a
Set password for ' root ' @ ' localhost ' =password (' mynewpass4! ');mysql5.7 The password security check plug-in (Validate_password) is installed by default, and the default password-checking policy requires that the password must contain:
1. Why duplicate data appears when two tables are connected2. What is the connection process of the table?Example:Table A:10Table B:1002EXECUTE statement: SELECT * from A join B on a.id = b.id;The order is as follows:Tables formed by join:1 11 01 01
Characteristics of relational database 1, the data appears in tabular form2, the names of the various records for each behavior3, the data field corresponding to the data name for each column4 Many rows and columns form a table5 several forms
A stored procedure, which can be understood as a logical SQL statement.Advantage: Execution is very efficient, and stored procedures are performed on the server side of the database.Disadvantage: The portability is poor, and the stored procedures of
1.1 MySQL Installation and basic configuration (CentOS 7.3)1. Install MySQL using yumYum Install Mysql-community-server2. Common commands for MySQL managementSystemctl Status MysqldSystemctl Start mysqldSystemctl Stop Mysqld3. Boot startSystemctl
The effect is, with 2/8 principles, M.F.B. s to solve most things. So kick, limited to the overall adjustment, not involved in specific details.1, InnoDBUsing the InnoDB engine2, Innodb_buffer_poolAdjust and innodb about the parameters, as much as
Linked table QueryInternal connection ' [inner| Cross] JOIN 'Unconditional Internal connection:Unconditional internal connection, aka Cross connect/Cartesian connectionEach item in the first table will be combined with each of the other tables in
BackgroundIn the case of e-commerce shopping, when we click on the shopping, the backend service will reduce the inventory operation of the corresponding goods. In the case of single-instance deployments, we can simply use the lock mechanism
Creation of foreign keysMethod 1: Set the table when creating (the foreign key name is randomly generated)1. Prerequisites, must have a master table, which is set to persons2. Primary key field must be set in Main Table primary key, this is set to
1. Install Pymysql via PIP to enter the cmd input pip install Pymysql Enter to wait for the installation to complete, the installation is complete after the relevant information, indicating that the installation was successful. 2. Test Connection
Inserting dataForm 1:Insert into table name (field name 1, field Name 2, ...). Values (value A1, value A2, ...), (Value B1, value B2, ...), ..... ;Form 2:Insert into Table name 1 (field name 1, field Name 2, ...). ) Select Field Name 1, field Name 2,
Write in front:These two days to a demand, configure the deployment of two servers MySQL data synchronization, tossing two days to check a lot of relevant information, has not even, and later found that the database is actually authorized IP has
The default setting method for datetime type in mysql, mysqldatetime
An error occurred while modifying the default datetime value through the navicat client.
The field type of the database table is datetime. The default value is NULL. When the
Introduction to Mysql isolation level, lock and MVCC, mysql isolation level mvcc
This article aims to clarify the relationships between these concepts and their functions. Understand the lock operation and MVCC version control when each SQL
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