Tag：mysql
-
[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 […]
-
MySQL 8.0.34 and Navicat Premium 12 Installation and Configuration Tutorial
Tutorial Catalog MySQL Installation and Configuration Tutorial 8.0.34 (Hands-on Super Detailed Graphic Tutorial)I. Non-first-time installations (skip to the next section if this is the first installation)II. First Installation1, in the browser search “MySQL” to enter the official website, it is recommended to use “Bing” search!2、Enter the official website, select “Download” to enter the download page.3. […]
-
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 […]
-
MySQL Installation Tutorial
I. MySQL Download (Installation Version) 1. Go to the official MySQL website Official website address:https://www.mysql.com/ 2. Click [DOWNLOADS]. 3. Scroll down and click [MySQL Community (GPL) Downloads] to download MySQL Community Edition. 4. Click [MySQL Installer for Windows] to download the MySQL installer. 5. You will then come to the MySQL latest version download page.（”MySQL […]
-
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. […]