Using Navicat to connect to Mycat 8066, the Database Sharding table and global table are successfully inserted.
1. The global table SQL is as follows:
Insert into 't_ rank 'values ('259bfdc3-7922-4839-96c7-61c89e877dc5 ', 'French', '7', '11', '11', '12', null, '34 ');
Insert into 't_ rank 'values ('41eece5d-9d86-4cfe-b0ce-e6d4e4021cac ', 'China', '2', '38', '27', '23', null, '88 ');
Insert into 't_ rank 'values ('4ae59e99-5f41-4a68-af07-65c15f72b247 ', 'Korea', '5', '13', '8', '7', null, '28 ');
Inserted successfully!
2. The Database Sharding table SQL is as follows:
Insert into't _ user_label 'values ('00041fc4-5947-11e6-a45d-fa163ee05659 ', '1ae56f42-dd56-4c00-9cf7-c580f428e20d', '0', null, 'work', '13', null, '123', '123', null );
Insert into't _ user_label 'values ('00067f28-594c-11e6-a45d-fa163ee05659 ', '95dc53e0-de02-41fd-85a6-3da25caba599', '0', null, 'work', '13', null, '123', '123', null );
Insert into't _ user_label 'values ('0006d1a6-5947-11e6-a45d-fa163ee05659 ', '1ae56f42-dd56-4c00-9cf7-c580f428e20d', '0', null, 'life', '3', null, '123', '123', null );
I thought these SQL statements were exported from mysql and there should be no errors, but an error is reported during execution.
[Err] 1064-partition table, insert must provide ColumnList
It means that the SQL statement is used to provide the description to be inserted, but I insert all columns, so I don't understand why?
3. Solution:
I added all the columns and found that they were successfully added:
Insert into partition (ACCOUNT_ID, ACCOUNT_NAME, CTAG, ACCOUNT_TYPE, ACCOUNT_STATUS, REGIST_CHANNEL, REGIST_TIME, ACTIVE_CHANNEL, ACTIVE_TIME, CALENDAR_VIEW, WEEK_FORMAT, primary, PROVINCE, MEAL, primary, secondary, REMIND_TIME_AHEAD, CREATE_TIME, LAST_UPDATE_TIME, LAST_LOGIN_TIME) VALUES ('0006f1b5-Hangzhou', '2017 @ 189.cn ', '0', '0', '2', null, '20170 ', null, null, '1', '0', '1', '1970 @ 189.cn', '9', null, null, '1 ', '{\ "sms \": 0, \ "email \": 1}', '123', '123', '123', null );