Using Navicat connection Mycat 8066 successfully inserted the Sub-Library table and global table
1. Global table SQL is as follows:
INSERT into' T_rank 'VALUES('259BFDC3-7922-4839-96C7-61C89E877DC5','France','7',' One',' One',' A',NULL,' the');INSERT into' T_rank 'VALUES('41EECE5D-9D86-4CFE-B0CE-E6D4E4021CAC','China','2',' -',' -',' at',NULL,' the');INSERT into' T_rank 'VALUES('4ae59e99-5f41-4a68-af07-65c15f72b247','South Korea','5',' -','8','7',NULL,' -');
Insert Success!
2, the Sub-database table SQL is as follows:
INSERT into' T_user_label 'VALUES('00041fc4-5947-11e6-a45d-fa163ee05659','1ae56f42-dd56-4c00-9cf7-c580f428e20d','0',NULL,'work',' -',NULL,'1470207308693','1470207308693',NULL,NULL,NULL,NULL);INSERT into' T_user_label 'VALUES('00067f28-594c-11e6-a45d-fa163ee05659','95dc53e0-de02-41fd-85a6-3da25caba599','0',NULL,'work',' -',NULL,'1470209456275','1470209456275',NULL,NULL,NULL,NULL);INSERT into' T_user_label 'VALUES('0006d1a6-5947-11e6-a45d-fa163ee05659','1ae56f42-dd56-4c00-9cf7-c580f428e20d','0',NULL,'Life','3',NULL,'1470207308711','1470207308711',NULL,NULL,NULL,NULL);
I would like these SQL to be exported from MySQL, should not be wrong, but the execution of the time error
[ERR] 1064-partition table, insert must provide columnlist
Look for the SQL to provide an indication of what to insert, but I am all-column inserted, so I don't understand why?
3, the solution:
I added all of the above, and found that add success:
INSERT intoT_user_setting (account_id,account_name,ctag,account_type,account_status,regist_channel,regist_time,active_ Channel,active_time,calendar_view,week_format,repeat_view,user_label_name,user_label_color,province,meal,is_ Need_remind,remind_type,remind_time_ahead,create_time,last_update_time,last_login_time)VALUES('0006f1b5-956d-4b2d-a3d7-baa10174b841','[email protected]','0','0','2',NULL,'1469936755211000',NULL,NULL,'1','0','1','[email protected]','9',NULL,NULL,'1','{\ "sms\": 0,\ "email\": 1}','600000','1469936755211000','1469936755211',NULL);
Find an explanation on the internet!
Mycat+mysql Insert data error I[err] 1064-partition table, insert must provide columnlist