MySQL 8.0 の薄い本／リンク集（第 3 章）

8.0.18 対応版はこちら

8.0.17・8.0.16 対応版はこちら

8.0.15 対応版はこちら

3.1 DDL

3.1.1 インスタント DDL

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html

https://www.s-style.co.jp/blog/2018/09/2525/

https://www.walksocket.com/archives/715

https://mysqlserverteam.com/mysql-8-0-innodb-now-supports-instant-add-column/

http://kenken0807.hatenablog.com/entry/2019/03/18/173600

3.1.2 カラムのデフォルト値指定の拡張（関数・式の利⽤）

https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html#data-types-defaults-explicit

https://yoku0825.blogspot.com/2018/10/mysql-8013default.html

https://mysqlserverteam.com/the-mysql-8-0-13-maintenance-release-is-generally-available/

3.1.3 不可視インデックス

https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html

https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html

https://www.s-style.co.jp/blog/2018/08/2275/

https://hit.hateblo.jp/entry/MYSQL8/INVISIBLE_INDEX

3.1.4 降順インデックス

https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html

https://variable.jp/2017/04/13/mysql8-0-descending-index%E3%81%AE%E3%82%B5%E3%83%9D%E3%83%BC%E3%83%88/

https://mysqlserverteam.com/mysql-8-0-labs-descending-indexes-in-mysql/

https://qiita.com/hmatsu47/items/8c5e7abe204f7ecc5084

3.1.5 関数・式インデックス

https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-functional-key-parts

https://yoku0825.blogspot.com/2018/10/mysql-8013_25.html

https://yoku0825.blogspot.com/2019/10/binlogformat-row-mysqldump.html

https://qiita.com/hmatsu47/items/128ece7276e4deac1477

3.1.6 主キーのないテーブルの禁⽌（sql_require_primary_key）

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_sql_require_primary_key

https://yoku0825.blogspot.com/2018/10/mysql-8013primary-key.html

https://www.slideshare.net/hidemifukamachi/sql-require-primarykey

https://gihyo.jp/dev/serial/01/mysql-road-construction-news/0109

3.1.7 CHECK制約

https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html

https://dev.mysql.com/doc/refman/8.0/en/table-constraints-table.html

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-foreign-key

https://mysqlserverteam.com/mysql-8-0-16-introducing-check-constraint/

https://yoku0825.blogspot.com/2019/04/mysql-8016checknot-enforced.html

http://next4us-ti.hatenablog.com/entry/2019/04/25/133554

https://elephantdolphin.blogspot.com/2019/08/check-constraints-issues.html

3.1.8 その他の DDL 新機能

https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-performance

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-character-set

https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html

https://dev.mysql.com/doc/refman/8.0/en/rename-table.html

https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html

3.2 管理⽤ SQL

3.2.1 RESTARTステートメント

https://dev.mysql.com/doc/refman/8.0/en/restart.html

https://www.s-style.co.jp/blog/2018/09/2527/

3.2.2 SET PERSISTステートメント

https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_persist_only_admin_x509_subject

https://www.s-style.co.jp/blog/2018/08/2262/

https://yoku0825.blogspot.com/2019/04/mysql-8015-set-persistonly.html