Programmer Think

Connect video MySQL installation configuration Installation and configuration of MySQL database mysql5.5 mysql5.6 mysql5.7(stable) mysql8 Later version Software download Mysql5.7 address: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-winx64.zip Special note If installed Mysql Think again, or in the process of making a ...

1, Restraint 1. Foreign key constraints Foreign key constraint concept Make the relationship between tables, so as to ensure the accuracy of data! Add foreign key constraints when creating tables Why foreign key constraints -- establish db2 database CREATE DATABASE db2; -- use db2 database USE db2; -- establish user User t ...

Introduction to JDBC Java Database Connectivity (JDBC) is an application interface in the Java language that specifies how client programs access the database, providing methods such as querying and updating data in the database. Database Driver What is a database driver? Similar to sound card driver, graphics card driver Our programs ar ...

1, BackgroundAfter the release of the last article on the road of order reconstruction, many small partners want to know how to realize the sub database and sub table. Then this article specifically introduces the actual combat of sub database and sub table.2, TargetThis paper will accomplish the following objectives:Number of sub tables: 256 n ...

innodb monitor overview innodb monitor is a built-in monitoring module of innodb. You can view it with show engine innodb status. innodb monitor output can be output in the error log To view finer grained innodb lock information, you need to open innodb_status_output_locks Type of innodb monitor There are two types of innodb monitor: innod ...

Stored procedures and functions MySQL supports stored procedures and functions from version 5.0. Stored procedures and functions can encapsulate complex SQL logic. Applications do not need to pay attention to the complex SQL logic inside stored procedures and functions, but simply call stored procedures and functions. 1. Overview of stored pr ...

catalogue 1, Why do I need multi table query? 🐟 Which city does an employee named "Abel" work in? 2, How to implement multi table query 1. Error of Cartesian product (cross connection) ① Wrong implementation ② Cause of error The query method of the table requires multiple conditions ① Join condition of two tables ② If a fiel ...

Guide: many friends analyze data for two minutes and run for two hours? In the process of using SQL, we should not only pay attention to the data results, but also pay attention to the execution efficiency of SQL statements. This article involves three parts with a long length. It is suggested to read it after collection: SQL introductio ...

mysql5.7 master-slave synchronization, mycat2 configuration, read-write separation (windows) This article is referenced and reproduced from the article MySQL5. Master slave configuration,mycat2 fast build,mycat2 read write separation configuration , only used to record your learning process 1, Mysql5 7 configure master-slave synchronization ...

mysql 5.7 installation Download yum source $ vagrant up # Start the virtual machine $ vagrant ssh # Connect to virtual machine # Download mysql 5.7 wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm Install yum source locally yum install -y mysql-community-server Check whether the mysql source is successfully i ...