MySQL

MySQL view the SQL statement being executedAugust 21, 2015 17:32:59 read: 15398 There are 2 ways of doing this:1, the use of processlist, but there is a disadvantage, is only to view the SQL statements being executed, corresponding to the history,

Integrity constraints---to ensure data integrity and consistencyKEY Point: Not NULL vs. default Unique Primary key Auto_increment FOREIGN key A NOT NULL with default1. Is it possible to emptyNULL NULLNot NULL is not

1 . Download MySQL repo source[[email protected] ~]# wget http://2. Install mysql-community-release-el7-5.noarch.rpm Package[Email protected] ~]# RPM-IVH mysql-community-release-el7-5. noarch.rpm3 . View the installed MYSQ source[[email protected] ~]

When learning MySQL, you may not understand the real purpose of delimiter, delimiter in many places in MySQL, such as stored procedures, triggers, functions and so on.Anyone who has learned Oracle will find it strange to learn MySQL.In fact, just

One, DDL (data definition Language) statement: the database definition language.These statements define different data segments, databases, tables, columns, indexes, and other database objects. Common statement Keywords: create, drop, alter, and so

1.1.Download:I downloaded the zip package for the 64-bit system:: https://dev.mysql.com/downloads/mysql/Download the ZIP package:Unzip after download: D:\ Software installation package \mysql-5.7.20-winx641.2.To Configure environment

Configure MySQL master-slave under native DockerInstall the Docker MySQL container first$ docker pull MySQL:5.6Pull two identical versions of MySQLStart MySQL separately and set the root user password to admin:// Master MySQL 3307:3306-d-e

One: MySQL user managementGrant all on . to ' user1 ' identified by ' passwd ';Grant Select,update,insert on DB1. To ' user2 ' @ ' 192.168.133.1 ' identified by ' passwd ';Grant all on DB1. To ' user3 ' @ '% ' of ' identified by ' passwd ';Show

Error, the database cannot be connected remotely.The first step is to turn off the local firewallAttention:Both connected machines need to be shut down.In the second step, two machines ping each other to see if they can access each other.Lost to

Directory Introduction to the Index The role of the index What kinds of common indexes are there? Normal index Unique index Primary key Index Combined index Index nouns Leftmost prefix Considerations for

One, MySQL dual master mutual Preparation +keeplived high-availability architecture IntroductionMySQL master-slave replication architecture can be a great guarantee of high availability of MySQL, in a master multi-slave architecture can also use

Single-Table query:Query specified record select .... whereQuery with in keyword not inRange query with between andSelect Column1,column2 from table1 where column between 3 and 14;Query with like% matches characters of any lengthQuery the name of

I am in centos6.5 version, 32-bit systemHost IP address 192.168.234.132 slave 192.168.234.131Install a simple MySQL cluster with a master bundleFirst, yum installation version 5.1.73Yum-y Install Mysql-server #安装mysql的服务端Installation Complete1.1

One, MySQL binary connection Use the MySQL binary method to access the MySQL database at the MySQL command prompt. Instance operations:[[email protected] ~]# mysql -uroot -pEnter password:#登录成功出现以下信息Welcome to the MySQL monitor.

Ext. 546915901. Generating ideasUsing MySQL memory table insertion speed features, first use functions and stored procedures in the memory table to generate data, and then inserted from the memory table in the normal table2. Create memory table and

First, the concept of triggerTrigger (Trigger): Monitors a situation and triggers an action, which is a way to provide programmers and data analysts with the assurance of data integrity, which is a special stored procedure associated with a table

Example tablecreate table tb_demo( id int unsigned auto_increment primary key, title varchar(50) not null default '', contents text, add_time int unsigned default 0);Inserting test datainsert into tb_demo (title,contents,add_time) values ('#1

The purpose of MySQL performance optimizationHow to design the database rationally?What database design can provide the cornerstone for post-DBA optimization?The difference between database design and program design?Early optimization of database

　　The last article just wrote the installation of MySQL, want to use Navicat to connect, and then error, here record error resolution.Navicat client does not support authentication protocol requested by server when connecting to MySQL Server8.0

Summary of today's mainstream databases: 在数据库技术日益发展的今天，主流数据库代表着成熟的数据库技术。了解常用数据库，就能知道数据库技术发展的程度，以及未来的大体方向。 数据库分关系型数据库和非关系型数据库。 关系型数据库：基于关系模型的数据库系统，是关系模型应用到数据库领域的实例化。它的基本概念来自于关系模型。市场上主流商业关系型数据库有SQL Server、Oracle、IBM DB2、MySQL等