columnlist专题
![做mycat分库分片时报Mycat+Mysql 插入数据报错 i[Err] 1064 - partition table, insert must provide ColumnList错误](/front/images/it_default2.jpg)
做mycat分库分片时报Mycat+Mysql 插入数据报错 i[Err] 1064 - partition table, insert must provide ColumnList错误
错误原因:mysql数据库导出时,没有加列名,比如说 insert into users values(1,'zs') 解决办法:导出mysql数据时,全部加上列名即可解决. 例如:insert into users(id,name) values(1,'zs');