COSCUP x RubyConf TW 2021

MySQL 8.0的新SQL為開發者開啟一片天
08-01, 14:40–16:00 (Asia/Taipei), TR213
Language: 漢語


Translate Title

New SQLs from MySQL 8.0

Talk Length

45

您是否知悉並同意如採遠端形式分享,需提供預錄影片(您需同意大會才能接受您的稿件) – yes Target audience

Developer, Architect, Application Analyst, DBA, Business Analyst

Difficulty

中階

講者所屬的公司或組織名稱

甲骨文公司

講者所屬社群

台灣MySQL User Group

other info

順道談基本SQL指令

hackmd url

https://hackmd.io/@coscup/BJUbHaPRu/%2F%40coscup%2FByWZSpP0O

slido url

https://app.sli.do/event/cc6xv6yq

Abstract

為了讓IT開發者更喜歡用MySQL,甲骨文不斷在MySQL上投注資源,完備它的SQL語句處理能力,和改進複雜SQL性能,尤其在MySQL 8.0,不論是自正式發開始,還是隨之而來的每一個更新版都有新的東西加進來.我將在這場演講中和大家一起探索這些不是那麼顯眼,然而對開發者又是非常好用的新SQL和優化器的進步.

English Abstract

In order to let IT developers prefer to use MySQL more, Oracle continues to invest resources on MySQL, to complete its SQL processing ability, and improve the performance of complex SQL, especially in MySQL 8.0, not only when its first GA but also in in each update there are many new SQL and optimizer improvement on this DBMS. In this talk I will share you these are not so conspicuous, but are very useful new SQLs and optimizer improvement for developers with the audience.