greatsql> SELECT TABLE_TYPE,ENGINE,count(*) FROMinformation_schema.tables WHERE table_schema='jcdb' GROUP BY TABLE_TYPE,ENGINE;+------------+--------+----------+| TABLE_TYPE | ENGINE | count(*) |+------------+--------+----------+| BASE TABLE | InnoDB |     1355 || BASE TABLE | MyISAM |        1 || BASE TABLE | MEMORY |        1 || VIEW       | NULL   |        3 |+------------+--------+----------+4 rows in set (0.02 sec)

greatsql> CREATE TABLE t0(id int primary key) ENGINE=MEMORY;Query OK, 0 rows affected (0.03 sec)
greatsql> INSERT INTO  t0 SELECT 1;ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin.

greatsql> SELECT count(table_name)FROM information_schema.tables WHERE table_schema = 'jcdb' AND table_name NOT IN (    SELECT table_name     FROM information_schema.table_constraints     WHERE constraint_type = 'PRIMARY KEY');+-------------------+| count(table_name) |+-------------------+|                67 |+-------------------+1 row in set (0.10 sec)

$ grep MyISAM jcdb.sql ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统日志表' ROW_FORMAT = DYNAMIC;$ sed -i 's/ENGINE = MyISAM/ENGINE = InnoDB/g' jcdb.sql$ grep MyISAM jcsh.sql 

-- 主键相关的参数greatsql> SHOW variables LIKE '%primary%';+------------------------------------+-------+| Variable_name                      | Value |+------------------------------------+-------+| sql_generate_invisible_primary_key | OFF   || sql_require_primary_key            | OFF   |+------------------------------------+-------+2 rows in set (0.00 sec)
greatsql> SET  sql_require_primary_key=on;Query OK, 0 rows affected (0.00 sec)
greatsql> CREATE TABLE t01(id int) ;ERROR 3750 (HY000): Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
greatsql> SET sql_require_primary_key=OFF;
greatsql> SET sql_generate_invisible_primary_key=ON;Query OK, 0 rows affected (0.00 sec)
greatsql> CREATE TABLE auto_1 (c1 VARCHAR(50), c2 INT);Query OK, 0 rows affected (0.26 sec)
greatsql> SHOW CREATE TABLE auto_1\G;*************************** 1. row ***************************       Table: auto_1Create Table: CREATE TABLE `auto_1` (  `my_row_id` bigint unsigned NOT NULL AUTO_INCREMENT /*!80023 INVISIBLE */,  `c1` varchar(50) DEFAULT NULL,  `c2` int DEFAULT NULL,  PRIMARY KEY (`my_row_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci1 row in set (0.00 sec)
ERROR: No query specified
greatsql> INSERT INTO  auto_1(c1,c2) VALUES('aaa',1);Query OK, 1 row affected (0.04 sec)
greatsql> INSERT INTO auto_1(c1,c2) VALUES('aabb',10);Query OK, 1 row affected (0.03 sec)
greatsql> SELECT * FROM auto_1;+------+------+| c1   | c2   |+------+------+| aaa  |    1 || aabb |   10 |+------+------+2 rows in set (0.00 sec)-- 默认情况下，SELECT 的时候不会显示不可见主键