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
http://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://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
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://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
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://www.s-style.co.jp/blog/2018/08/2262/
https://yoku0825.blogspot.com/2019/04/mysql-8015-set-persistonly.html