MySQL

I. ClassificationPRIMARY Key (PK) identifies the field as the primary key of the table and can uniquely identify the record foreign key (FK) identifies the field as the foreign key of the table not NULL identifies the field cannot be empty unique

#添加学生信息INSERT into student VALUES (' 108 ', ' Zeng Hwa ', ' Male ', ' 1977-09-01 ', ' 95033 ');Insert the above information data in MySQL, MySQL has the following error1 queries executed, 0 success, 1 errors, 0 warningsQuery: INSERT into teacher

First download mysql57-community-release-el7-11.noarch.rpmDockerfile from hub.c.163. Com/library/centos:latestmaintainer zhenweilai @qq. com > COPY mysql57-community-release-el7-11. noarch.rpm/usr/localRUN cd/usr/ Local && yum localinstall-y mysql57

#inner join equivalent connection/INNER JOINMysql> Select * frominfo;+------+-------------+----------+|Name|Phone|Address|+------+-------------+----------+|Zhao| 13199999999 |Beijing||Qian| 1328888888 |Harbin||Sun| 13366666666 |Shanghai|+------+---

In Windows when we installed MySQL:1. The concept of a transactionA transaction is a set of SQL statement operations, and the individual SQL statements that make up this set of operations must all succeed in order to result. Any SQL statement

Select is used to query a table or execute a function, and show queries the statement that created the table or other resource | Connection Database mysql-uroot-p Password | Show database version select version (); View all databases show databases;|

-Transactional four-character (ACID) atomicity: (atomicity): The operation of a transaction is indivisible, either complete or not executed. Consistency: (consistency) Isolation: (Isolation) Persistence: (durability) operation instruction for mysql--

Defines a complex logic for batch processing of SQL statements, creating delimiter //  modification terminators through a name store--  stored procedures have no return value delimiter //     ----  put Terminator; Modify to//create procedure porc2 ()

Read Catalogue An introduction Two Insert data inserts Three Update data updates Four delete data deletes Five query data Select back to topAn introductionMySQL Data manipulation: DML=====================================

When we installed the MySQL database, the installation failure is a very annoying thing, the next small set to everyone in our installation of MySQL database failed some of the solutions, interested in small partners can refer toMySQL database is

Mysql 5.7.18 zip version installation and configuration method graphic tutorial (win7), 5.7.18win7 Mysql5.7.18zip is installed in windows. It can be decompressed, initialized, and used after some password modification settings. To connect remotely,

Linux uses binary to install mysql and binarymysql The following example shows how to install mysql using binary in linux. 1. download binary files Download mysql-5.6.36-linux-glibc2.5-i686.tar.gz on official website. 2. decompress the file and

Analyze the four transaction isolation levels in MySQL using an instance, and analyze mysql using an instance Preface In database operations, the transaction isolation level is proposed to effectively ensure the correctness of Concurrent Data

Basic installation tutorial for mysql decompression package and basic mysql decompression tutorial Because the new computer is changed, the environment must be configured on the new computer. I suddenly found that the mysql configuration was

MySQL 4.1/5.0/5.1/5.5/5.6/ Command differences of different versions: show innodb status\G mysql-5.1show engines innodb status\G mysql-5.5 User @ '%' about grant authorization mysql-5.5 does not contain localhost -------------------------------------

MySQL pre-processing statements prepare, execute and deallocate usage tutorial, preparedeallocate Preface MySQL officially calls prepare, execute, and deallocate collectively referred to as prepare statement. I used to call it a [pre-processing

Solution to data asymmetry between MySQL and Elasticsearch: mysqlelasticsearch Solutions to data asymmetry between MySQL and Elasticsearch Jdbc-input-plugin can only be used to append data to a database. elasticsearch writes data incrementally.

Detailed description of time-consuming SQL instances recorded by mysql, and detailed description of mysqlsql instances Mysql records time-consuming SQL statements Mysql records time-consuming SQL statements or SQL statements without indexes in slow

Mysql Single Table Record query, Mysql Single Table RecordData Record query: 1. simple data record query: select * from table_name; select allfield from table_name; select distinct (attribute name) from table_name; // avoid repeated query to

MySQL constraints, multi-table queries, subqueries, mysql constraint table queries 1. Primary Key constraints Constraint: A constraint is added to a column to constrain the column. 1. primary key constraint (unique identifier): non-empty, unique,