The table does not comply with the requirements by an external plugin.问题修改

问题描述：Mysql8版本，运行sql语句复制一张表结构和数据

开发中想复制base_organize表，运行了sql语句：

create table kj_organize select * from base_organize; 

报错The table does not comply with the requirements by an external plugin.

后百度发现是因为新建的表kj_organize没有主键。

说明此sql只会复制表字段，不会复制主键，索引，约束等

后改为先复制表结构，后插入数据

-- 复制表结构
CREATE TABLE kj_organize LIKE base_organize;
-- 插入表数据
INSERT INTO kj_organize SELECT * FROM base_organize;

特此记录