Category：Database
-
DevChat Helper: Practicing on top of database and data analytics applications
Article Catalog I. About Devchat 1.1 What problem DevChat is used to solve 1.2 DevChat’s greatest strengths 1.3 How Developers Use DevChat Installation and configuration of DevChat 2.1 Installing DevChat in vscode 2.2 Obtaining and Configuring an Access Key 2.3 Test the configuration for success III. Testing support for database operations 3.1 Database and Data […]
-
[MySQL] Don’t Allow Data You Don’t Know How to Insert
Article Catalog Previously on MySQL Details of this chapter Data insertion Insert complete rows Inserting multiple rows Insert the retrieved data How to consolidate learning Summary of this article Previously on MySQL Hello everyone, today is the nth time I write about MySQL, but also recently learned MySQL, and also want to record my learning […]
-
Indexes in MySQL
Article Catalog 1. Overview of the index1.1 Index Overview1.2 Advantages1.3 Disadvantages1.6 Common Indexing Concepts1.6.1 Clustered Indexes1.6.2 Secondary indexes (auxiliary indexes, non-clustered indexes)1.6.3 Federated indexes 1.8 Principles of MyISAM Indexing1.9 MyISAM vs InnoDB1.10 Cost of Indexing 2. Principles of index creation and design2.1 Declaration and Use of Indexes2.1.1 Classification of indexes2.1.2 Creating indexes2.1.2.1 Creating indexes when […]
-
Mysql Query Statements
simple query ## Direct query Syntax: select field from table name; For example, select name, age from student; Ans: Query name and age from the student table. ## Conditional queries Syntax: select field from table name where Condition; For example, select name from student where age = 15; Ans: Query the student table for name […]
-
JDBC Connecting to MySQL
catalogs I. Beginning II. Introduction 1, the concept of JDBC 2、Functions of JDBC 3, JDBC common interfaces and classes III. Database creation (MySQL) 1. Connecting to MySQL (1), register the driver (2) Getting Connected (3), get the executor connection (4), execute the SQL statement, and accept the results (5), processing results (6) Release of resources […]
-
MySQL Table Additions, Deletions and Changes (Basic)
Article Catalog ☕️1. CRUD☕️ 2. Create 2.1 Single-line data + full-column insertion 2.2 Multiple Rows + Specified Column Insertion 2.3 Insertion format on time (homework data table): 3. Query (Retrieve) 3.1 Full-column queries 3.2 Specified Column Queries 3.3 Query Fields as Expressions 3.4 Alias 3.5 De-weighting: DISTINCT 3.6 Sorting: ORDER BY 3.7 Conditional queries: WHERE […]
-
Logistics transportation information management system design and implementation
catalogs 1 System overview 2 System-related technologies 3 Requirements analysis 3.1 Needs analysis concepts 3.1.1 User workflow analysis 3.1.2 Analysis of user work requirements 3.2 System Functional Requirements Analysis 3.3 System Functional Use Case Analysis 3.3.1 Participants 3.3.2 Participant use case analysis 3.4 System feasibility analysis 4 System Design 4.1 Overall system functional design 4.2 […]
-
mysql enable remote access privileges
1. Login to MySQL mysql -u root -p Enter your password 2. Select mysql database use mysql; Because the mysql database stores the user table with user information. 3. View information about the current root user in the user table of the mysql database. select host, user, authentication_string, plugin from user; After executing the above […]
-
Simple to implement a library management system with a database
catalogs I. Summary 2、Basic Functions 2. Foreword 3. Subject 3.1 Needs analysis 3.1.1 Data needs analysis 3.1.2 Functional requirements analysis 3.2 Outline design 3.2.1 Data dictionary 3.2.2 ERD (Entity Relationship Diagram) 3.2.3 DFD data flow diagrams 3.3 Logic Design 3.3.1 Conversion rules for E-R models to relational models 3.3.2 Conversion of the E-R diagram to […]
-
DML statements in SQL
preamble Previously we have explained DDL statements in SQL statements. Today we will continue with the DML statement of SQL. DML is the Data Manipulation Language.Used to add, delete, and change data operations on the tables in the library.。 1. Add data to the specified field(INSERT) 2. Modify data(UPDATE) 3. Delete data(DELETE) catalogs preamble I. […]