Advanced Mysql - multi table query - foreign key constraint

Why have multiple watches? – create an employee table, including the following (id, name, age, dep_name, dep_location),id primary key, automatic growth, and add 5 pieces of data Code example: CREATE TABLE emp ( id INT PRIMARY KEY auto_increment, name VARCHAR(40), age int, dep_name VARCHAR(40), dep_location VARCHAR(30) ); INSERT INTO em ...

Posted on Wed, 03 Nov 2021 18:51:05 -0400 by lihman

MySQL Database (5/5) Python Operations MySQL and Actual Warfare

Python Operates MySQL and Actual Warfare Course Objectives: Master transactions and locks as well as Python development prerequisites for operating MySQL. Course Summary: Transaction: Atomic operations succeed or fail. Locks: If many people are working on the database at the same time, data clutter may occur. MySQL's own locks can solve this ...

Posted on Wed, 03 Nov 2021 14:18:17 -0400 by kevinbarker

Mysql advanced part

9. Mysql advanced 9.1 data addition Learning objectives: understand some advanced operation skills in new data, and improve the efficiency and security of data insertion Batch insertWorm replicationPrimary key conflict Conflict updateConflict replacement 9.1.1 batch insertion concept Batch insert: it is a way to optimize the ...

Posted on Tue, 02 Nov 2021 17:46:11 -0400 by Eal

Introduction to Spring framework -- Spring transaction

catalogue Chapter 5: Spring transactions 5.1 transaction management in spring 5.1.1 review of affairs 5.1.2 transaction management in spring 5.2 API of spring transaction management 5.2.1 transaction manager 5.2.2 transaction definition interface 5.2.3 timing of spring committing and rolling back transactions 5.2.4 summarizing Spring t ...

Posted on Tue, 02 Nov 2021 16:18:32 -0400 by spags

Mysql tuning: implementation of four Mysql partition methods and combined partitions

Before reading this article, you need to understand the following questions~ 1, Question 1. What is the partition Partition: it is to store a table data in blocks Objective: to improve the query efficiency of the index 2. Why should MySQL use partitions Start with data analysis Then index optimization is performed Then introduce the par ...

Posted on Tue, 02 Nov 2021 11:49:04 -0400 by kayess2004

MySQL advanced SQL statement III

catalogue 1, Connection query 1. Inner connection 2. Left connection 3. Right connection 2, Database function 1. Mathematical function 2. Aggregate function 3. String function 4. Date time function 2. Advantages of stored procedures 3. Create stored procedure 4. Modify and delete stored procedures summary 1, Connection query M ...

Posted on Mon, 01 Nov 2021 19:58:52 -0400 by hazel999

MySQL functions and stored procedures

1, Database function 1. Mathematical function The records stored in the database often need a series of arithmetic operations, so MySQL supports many mathematical functions. Common mathematical functions Mathematical functiondescribeabs (x)Returns the absolute value of x; The absolute value is always positive, and the absolute value o ...

Posted on Mon, 01 Nov 2021 18:19:23 -0400 by hagman

MySQL master-slave replication, read-write separation theoretical analysis + practical demonstration

introduction In enterprise applications, mature businesses usually have a large amount of data. If the reading and writing of MySQL database are operated on one database server, it can not meet the actual needs in terms of security, high availability, high concurrency and so on. Therefore, generally speaking, the Master-Slave replication ...

Posted on Mon, 01 Nov 2021 05:41:36 -0400 by divedj

Experiment: student management system based on C#

catalogue preface 1, Preliminary preparation 1. Create a new project and connect to the database 1.1 download MySQL 1.2 on the initial interface of vsial studio 2017, click file - > New - > project, find the Windows form application, modify the project name to xscj, and click save   1.3 four main objects connected to the databa ...

Posted on Sat, 30 Oct 2021 10:33:31 -0400 by Maugrim_The_Reaper

Large MySQL database learning series

Data CRUD operation CRUD refers to create, retrieve, update and delete. It is also what we often call add, delete, modify and query. insert data 1. Insert a single piece of data INSERT INTO Table name VALUES(val_list); INSERT INTO Table name(col_list) VALUES(val_list); 2. Insert multiple pieces of data INSERT INTO Table name(col_list) ...

Posted on Fri, 29 Oct 2021 11:58:38 -0400 by razta