MySQL 語法 - HackMD

Java 016
·
Last edited by Victor Liang on Mar 7, 2023
Linked with GitHub
Contributed by

Edit

There is no commentSelect some text and then click Comment, or simply add a comment to this page from below to start a discussion.

排序

ROW_NUMBER() = INDEX ( 1 2 3 4 5 6 )

ROW_NUMBER() OVER ( ORDER BY number ) as 'index'

RANK() = 非連續排名 ( 重複名次時會跳過下一名 ex: 1 1 3 4 4 6 )

RANK() OVER ( ORDER BY score ) as 'rank'

DENSE_RANK() = 連續重複排名 ( ex: 1 1 2 3 4 5 )

DENSE_RANK() OVER ( ORDER BY score ) as 'dense_rank'

Last changed by

Java 016

雜

Spring Boot build docker image

指令: mvn spring-boot:build-image image 名稱參數: -Dspring-boot.build-image.imageName=myrepo/myimage Reference Build a Docker image using Maven and Spring Boot

May 4, 2023

Mock RTSP Stream

Host By Android Studio Emulator With RTSP Security Server terminal 1 emulator -avd [device_name] emulator power on wait till Boot completed open RTSP Security Server App terminal 2

Apr 14, 2023

聯級管理 OneToMany orphanRemoval - 若 Many 方在 One 方修改後無對應的關聯對象，則自動刪除。example: @OneToMany(mappedBy = "parent", cascade = CascadeType.ALL, orphanRemoval = true) private List<Child> children = new ArrayList<>(); 修改前 { "id": "parent"

Mar 7, 2023