2020 年 3月 17 日随笔档案 - jinzhenshui

2020年3月17日

Mysql：SQL Modes：最令我烦的sql-modes：一个标准它不香么？！

摘要：核心：所谓的各种sql mode就是mysqld的各种语法检查开关。原则：如果你不想有各种烦恼：不要去设置它！提示：如果你想设置它，尽量兼容国际标准。 The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_ 阅读全文

posted @ 2020-03-17 11:39 jinzhenshui 阅读(544) 评论(0) 推荐(0)

Mysql：Alternative Storage Engines：可替换存储引擎：mysqld的核心特性

摘要：请注意：NO_ENGINE_SUBSTITUTION Chapter 16 Alternative Storage Engines Table of Contents 16.1 Setting the Storage Engine Storage engines are MySQL componen 阅读全文

posted @ 2020-03-17 09:27 jinzhenshui 阅读(426) 评论(0) 推荐(0)

Mysql：The BLACKHOLE Storage Engine

摘要： Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated t 阅读全文

posted @ 2020-03-17 09:05 jinzhenshui 阅读(184) 评论(0) 推荐(0)

Mysql：The ARCHIVE Storage Engine

摘要：记录下，尚不知如何用？！ 16.5 The ARCHIVE Storage Engine The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in 阅读全文

posted @ 2020-03-17 08:57 jinzhenshui 阅读(228) 评论(0) 推荐(0)

Mysql：The CSV Storage Engine

摘要：注意： 1）表定义（换句话说）数据列必须不能为空Null！ 2）修复表，极有可能丢失数据 16.4 The CSV Storage Engine 16.4.1 Repairing and Checking CSV Tables 16.4.2 CSV Limitations The CSV stora 阅读全文

posted @ 2020-03-17 08:46 jinzhenshui 阅读(281) 评论(0) 推荐(0)

Mysql：The Memory Storage Engine

摘要： 16.3 The MEMORY Storage Engine The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memo 阅读全文

posted @ 2020-03-17 08:45 jinzhenshui 阅读(188) 评论(0) 推荐(0)