配置mycat中间件使用 Navicat连接时 报错
There is no primary key here. Update will only use exact matching of the old values of the columns here. Thus, it may update more than one record.
解决方案:
修改 mycat 配置 schema.xml
checkSQLschema=“false” 修改成 true;
checkSQLschema
当该值为true时,例如我们执行语句select * from TESTDB.company 。mycat会把语句修改为 select * from company 去掉TESTDB。