MySQL

Compile and install MARIADB on CENTOS7 and implement multi-instancePlease read the 7th and 8th of the preparation, and it is recommended to install both packages before compilingPreparatory work:1 iptables off; SELinux off systemctl stop

MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.View current configurationShow VARIABLES like

The content of this article: System variables User variables Local variables Starting Date: 2018-04-18 System variables: System variables are variables that the system has already defined in advance.

Cmake-dcmake_install_prefix=/usr/local/mysql CMake Installing the installation path-dmysql_unix_addr=/home/mysql/mysql.sock Specify a home directory-DDEFAULT_CHARSET=UTF8 specifies that the character set specifies

This article directory:1. Create and Modify views2. View algorithm Merge, temptable3. Deleting and viewing View information4. Check for invalid viewsA view is a type of table expression, so it is also a virtual table. When you view an operation, the

Locate the previous MySQL installation package and reinstall MySQL.1. Set the environment variable, WIN10 can right-click this computer-properties, add the path of the MySQL file bin in the system variable path2. Modify the configuration file

#外键 table linked to table column name MUL foreign key referential integrity cannot add a field that does not have another tableCREATE TABLE Study_record (ID int auto_increment PRIMARY key,Day int is not NULL,Status char (+) NOT NULL,stu_id int NOT

First, using the command line mode into MySQL will see the first prompt;View version Information#1使用命令行模式进入mysql会看到最开始的提示符Your MySQL Connection ID is 3Server version:5.1.69 Source DistributionSecond, the command line using status can be

The lock in MySQL InnodbLock is a necessary means to resolve concurrency conflicts, concurrency in MySQL mainly refers to the simultaneous operation of multiple threads on the same database, where different threads may represent different

The barcode value that would have been deleted in the Error_barcode table is repeated only one table structure as follows (Ps:id is self-growing, the figure is deleted successfully so ID is not contiguous)The SQL statements are as follows:DELETE

Delete from where not inch Select Max from Group by title)Just started using this statement to delete has not been successfulThen Baidu a bit, said is to create a temporary tableAs a result, the following actions are performedCreate a temporary

Manually compiling and installing MySQL on a virtual machine Linux system1, first of all the MYSQL-5.5.24.TAR.GZ source code package ready, extracted to the virtual machine Linux/opt folder.2. Install the necessary basic tools through the Yum

First, MySQL database master-slave replication principleMySQL master-slave replication is actually based on binary logs, and the principle can be represented by a graph:Divided into four steps to go:1. The main library writes all the logs generated

(1) Preparation environment 1) Create an employee tablemysql> create table company.employee6( -> emp_id int auto_increment primary key not null, -> emp_name varchar(10), -> age int, -> dept_id int);mysql> insert into

RelationshipThe relationship between entities and entities is reflected in the design of the final database table. Divide the relationship into three categories: one-to-one, two-to-many (many-to-a) and many-to-many.All relationships refer to the

One, Description: The table is named student1, Query the field in a tableSelect Field Name 1, field name 1 form student;Example: Querying the sname in studentSelect sname from student;2, Query the field in a table (there are duplicate contents

Login/exit Basic operations1. Enter Mysql-u root-p in cmd to log in to MySQL service2. Quit, or exit; Exit3.show databases; into the library4 ues library name; Select Database example: Use MySQL;5. See what tables are in the database show tables;6.

Description: Student is the name of the table to be createdPrimary key: Primary keyNote: Comment1, create the table:CREATE TABLE Student (Sno varchar () NOT NULL primary key comment ' study number ',Sname varchar (a) NOT null comment ' student name '

Controller:Private ReadOnlyVipviewmodel _model =NewVipviewmodel (); Public Static stringMSG;//Get:systemmanage/renzheng[HttpGet] PublicActionResult Index (intpage =1) { #regionData is populated to the custom modelvardb

1. Create a userCREATE USER 'Dingyingsi'@'localhost'Identified by 'dys123';//Create the user on this computerCREATE USER 'Dingyingsi'@'%'Identified by 'dys123'; The user created can connect to the computer remotely2. AuthorizationGrant Select,Insert,