Training camp learning notes (sql)

Task01: getting to know database and SQL catalogue 1, First knowledge database 1.1 types of DBMS 1.2 common system structure of RDBMS 1.3 database installation 1.3.1 introduction to Alibaba cloud MySQL server 1.3.2 introduction to building local MySQL environment 2, First knowledge of SQL 2.1 concept introduction 2.2 basic writing rules of SQL ...

Posted by GooberDLX on Tue, 23 Nov 2021 17:53:56 -0800

Grinding 23 kinds of big talk design modes ----- decorator mode (decorator mode)

Hello, everyone. I'm a student in the java learning circle who doesn't want to disclose my name and lives a shoddy life. If there are mistakes in the article, I hope Haihan. You're welcome to make more corrections If you get useful dry goods knowledge from this article, please give me a favor. It is said that all the likes have got offer s ...

Posted by andr923 on Tue, 23 Nov 2021 17:39:27 -0800

oracle database foundation: DQL language foundation

The table.sql file used for testing was uploaded to my resource library... If you want to use it, you can use the following three tables for testing only. The specific contents of each table are as follows: Department table Area table Employee table There are too many specific contents. Some contents are displayed here 1. Basic quer ...

Posted by lawnmowerman on Tue, 23 Nov 2021 06:45:14 -0800

Oracle 21c new feature: Immutable tables to improve security

The block linked list of Oracle 21c is the most concerned feature, but there is another small feature rarely mentioned, that is Immutable tables - Immutable tables.The block linked list was introduced in 21c and then transplanted back to 19.10. The immutable list was introduced into Oracle 21.3 and 19.11 at the same time. Therefore, it can be c ...

Posted by lachhekumar on Tue, 23 Nov 2021 06:25:24 -0800

Mysql review notes - Fundamentals 7 [overview of database character set]

Character set, basic concepts of character order and their relations MySQL provides different character sets for data storage. In the data comparison operation, different character order support is provided. MySQL provides different levels of settings, including server level, database level, table level and column level, which can provide ver ...

Posted by lotrfan on Tue, 23 Nov 2021 01:48:27 -0800

Understand the modularity of NgModule~Angular

  catalogue @Class of NgModule() decorator Common system modules of Angular 1. Example - create and import feature modules order.module.ts list.component.ts app.module.ts app.component.html 2. Example - inert loading module order.module order-routing.module Configure in the top-level routing AppRoutingModule app.component.html im ...

Posted by optimiss on Tue, 23 Nov 2021 01:33:30 -0800

Create a short video and audio with Python j

Welcome to pay attention Python wechat ordering applet course video https://edu.csdn.net/course/detail/36074 Python practical quantitative transaction financial management system https://edu.csdn.net/course/detail/35475 pydub is a simple, convenient and powerful Python audio processing library Project address: https://github.com/jiaaro/p ...

Posted by Frame on Mon, 22 Nov 2021 21:31:41 -0800

MySQL master-slave replication - based on binlog

1, Overview MySQL performs real-time data synchronization and does not play back the executed import database script. Therefore, before synchronization, the data at both ends should be consistent. Data synchronization: Master slave replication (if the master database hangs up, the slave database will not automatically become the maste ...

Posted by n5tkn on Mon, 22 Nov 2021 12:16:53 -0800

Java in those let you love the manual tool library, refining the amount of code

Java in those let you love the manual tool library, refining the amount of code 1, New features of JDK1.8 Stream 1. Common generation methods of Stream ① Collections in the Collection system can generate streams using the default method stream() //list to stream List<String> list = new ArrayList<>(); Stream<String&gt ...

Posted by phppssh on Mon, 22 Nov 2021 10:08:01 -0800

MongoDB << connection to database and creation of data

1.mongodb official website MongoDB: the application data platform | MongoDB 2. Go to the official website of MongoDB and download MongoDB, MongoDB compass and Mongodb--database--tools 3. The operation of the MongoDB database by nodejs needs to rely on the third-party package mongoose of nodejs   Terminal instruction: npm install mongoo ...

Posted by nobodyk on Mon, 22 Nov 2021 07:15:39 -0800