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 Series Articles Home===============1 Preparing data1.1 Build Table drop table if exists employee; create table if not exists employee (ID int primary key auto_increment, name /span>varchar (40 Span style= "color: #000000"),

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

Basic syntax for queriesSELECT * from table name; The FROM keyword is followed by a table name, indicating that the data originates from this table The column name in the table after the SELECT, if * indicates that all columns in the

#外键 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

Forced to go to the MySQL database and found that when reading the database, the value of the tinyint type is converted to a Boolean, so that values greater than 1 are lost and become true. Check data MySQL does not have a Boolean type, are stored

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

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