MySQL database - things

preface MySQL transactions are mainly used to process data with large amount of operations and high complexity. For example, in the personnel management system, to delete a person, you need to delete both the basic data of the person and the information related to the person, such as mailbox, UTF-8...

Posted by jschultz on Mon, 25 Oct 2021 11:27:56 +0530

MySQL data processing function

Data processing function Data processing function is also called single line processing function; Single line processing function features: one input corresponds to one output. The opposite of single line processing function is multi line processing function: multiple inputs correspond to one UTF-8...

Posted by ashley526 on Mon, 25 Oct 2021 16:53:17 +0530

MySQL database backup (full backup and recovery)

catalogue preface 1, MySQL full backup 1. Detailed description of database backup methods 1.1 importance of database backup 1.2 classification of database backup 1.3 interpretation of MySQL full backup concept 2.mysqldump backup drill 2.1 packaging folder backup with tar 2.2 using mysqldump tooUTF-8...

Posted by liamjw on Tue, 26 Oct 2021 19:10:06 +0530

MySql database practice design commodity sales system

MySql database exercise Title Description: Now design the commodity sales system, including the following contents 1, Create table 1. Member form: used to record member information, including Membership form Field namemeaningexplainvipIdMember numberPrimary keyvipnameMember nameNon emptyvipsexMUTF-8...

Posted by cmburns69 on Tue, 26 Oct 2021 20:12:03 +0530

Mysql learning notes [dictionary]

database system (DataBase System´╝îDBS) form Software (database management system)databaseDatabase Administrator database It is an organized and shareable collection of large amounts of data stored in the computer for a long time. It is a "warehouse" of data. effect Structured storage of large aUTF-8...

Posted by nootropil on Thu, 28 Oct 2021 20:44:50 +0530

MySQL Database Experiment 2

Topic: Experiment 2: database and table management* Purpose requirements: 1. Understand the characteristics of logical structure and physical structure of MySQL database. 2. Learn to use SQL statements to create, select and delete databases. 3. Learn to use SQL statements to create, modify and UTF-8...

Posted by brandondrury on Fri, 29 Oct 2021 00:19:55 +0530

The performance test timed out deleting data, a large number of interface returns failed, and the database connection pool configuration parameter is too small

Performance test data deletion timeout, high interface error rate During the performance test, it was found that deleting data in a complex interface timed out and failed! 2021-10-28 20:16:07.228 [http-nio-10001-exec-167] error com.iot.handler.iotglobalexceptionhandler - = = = = > system operatUTF-8...

Posted by cornelombaard on Fri, 29 Oct 2021 05:00:05 +0530

Storage practice of massive vehicle status data in the scenario of Internet of vehicles

Author: Li XinbackgroundWith the continuous development of communication technology and computer technology, mobile communication is developing from people to people (H2H) to people to things (H2M) and things to things (M2M). The concept of "interconnection of all things" is gradually covering UTF-8...

Posted by callie212 on Sat, 30 Oct 2021 01:57:49 +0530

mysql database advanced statement - upper

catalogue 1, Common query 1. Sort by keyword grammar Single field sorting Conditional query (combined with where) Multi field sorting Interval judgment and query non duplicate records (and and or) Nested / multi conditional distinct query does not duplicate records 2. Group results grammar GrouUTF-8...

Posted by php12342005 on Sat, 30 Oct 2021 02:43:50 +0530

3 Advanced MySQL applications

1) Window function # 1 Grammar Function name([expr]) over(partition by order by rows between ) # 2 data range rows between 2 preceding and current row # From the first 2 lines to the current line rows between unbounded preceding and current row #UTF-8...

Posted by BillyT on Sat, 30 Oct 2021 16:11:35 +0530