MySQL knowledge summary, read this article is enough
1, Basic concepts of database 1. What is a database? Warehouse for storing and managing dataThe English word is: DataBase, abbreviated as DB 2. What are the benefits of databases? Data can be stored persistentlyEasy to store and manage dataThe database is operated in a unified way – SQL type 2,UTF-8...
Posted by stickynote427 on Fri, 08 Oct 2021 03:00:12 +0530
Use JDBC to connect to MySQL database and query data
1, MySQL installation 1. Installation Unzip the downloaded installation package Create a new my.ini file in the extracted directory Copy the following text into the my.ini file [mysqld] # Set 3306 port port=3306 # Set the mysql installation directory ---------- is your file path------------- bUTF-8...
Posted by Templar on Fri, 08 Oct 2021 12:17:24 +0530
MySQL Learning Summary - TCL (Transaction Control Language Summary)
All the database learning summary articles are summarized from the Silicon Valley video in Station B. The video links are as follows: [https://www.bilibili.com/video/BV12b411K7Zu] 1. Transactions 1. Definition An execution unit consisting of one or a set of SQL statements that either executes UTF-8...
Posted by mithril on Fri, 08 Oct 2021 21:31:02 +0530
MySQL multi table query and exercises
catalogue multi-table query one. Cartesian product two. Internal connection two point one Equivalent connection 2.2 natural connection 3. External connection 3.1 left connection 3.2 right connection Exercise exercise subject Tables used (Student table and SC table) answer multi-table query TherUTF-8...
Posted by pureDesi on Sat, 09 Oct 2021 08:52:49 +0530
MySQL Basics
Field type classification Differences between char and varchar types char: all spaces will be reserved on the bottom floor first varchar: the bottom layer will not leave empty spaces. The number of characters you enter will calculate the number of empty spaces Create tables with multiple field UTF-8...
Posted by bubblewrapped on Sat, 09 Oct 2021 12:10:22 +0530
MySQL database to achieve read-write separation
Catalogue of series articles Part IV: master-slave synchronization of MySQL database https://blog.csdn.net/m0_51864249/article/details/120687861?spm=1001.2014.3001.5501https://blog.csdn.net/m0_51864249/article/details/120687861?spm=1001.2014.3001.5501 Article catalog Catalogue preface 1, PrepaUTF-8...
Posted by mrvijayakumar on Sun, 10 Oct 2021 23:14:35 +0530
MySQL entry to mastery
1, Database 1. Overview database a warehouse used to store and manage data Classification: relational and non relational 2, SQL language 1. Overview It is a structured query language, which is specially used to operate databases. It is a standardized language that can operate various database UTF-8...
Posted by rodrigocaldeira on Mon, 11 Oct 2021 02:30:51 +0530
Mybatis-plus Learning Notes
Mybatis-plus Dependent Version Number 3.0.5 supplement This technology is based on SpringBoot technology to complete use Do not use with mybatis, it may cause resource mismatch Notes for version 3.0.5, the latest version may be used differently, choose carefully Set up use project process 1.ImpUTF-8...
Posted by FloridaNutz on Mon, 11 Oct 2021 21:52:47 +0530
Hive principle and practice: hive basic concept and installation
1. Basic concepts of hive Hive is a data warehouse tool based on Hadoop, which maps structured data into a table and provides SQL like query function. It can be understood here that it is based on Hadoop. It can convert SQL like statements (HQL supported by hive) into MapReduce tasks to run, sUTF-8...
Posted by missy3434 on Mon, 11 Oct 2021 23:58:56 +0530
MySQL database learning tutorial, from 0 to getting started
mysql day01 class notes 1. What is a database? What is a database management system? What is SQL? What is the relationship between them? Database: English words DataBase，abbreviation DB. A combination of files that store data in a format. As the name suggests: a warehouse for storing data is aUTF-8...
Posted by PHPslide on Tue, 12 Oct 2021 03:52:20 +0530