nickyjason 發表於 2022-2-20 15:32

各位大大救命啊~~~導入spr_action出現錯誤~

各位大大救命啊~~~導入spr_action出現錯誤~這是哪裡出現問題??
求教學

1062 - Duplicate entry '18621-5' for key 'PRIMARY'
INSERT INTO spr_action VALUES ('17973', '0', '24', '24');
INSERT INTO spr_action VALUES ('17973', '18', '32', '24');
INSERT INTO spr_action VALUES ('17973', '30', '33', '24');
INSERT INTO spr_action VALUES ('17973', '4', '36', '24');
INSERT INTO spr_action VALUES ('17974', '0', '20', '24');
INSERT INTO spr_action VALUES ('17974', '1', '23', '24');
INSERT INTO spr_action VALUES ('17974', '4', '32', '24');
INSERT INTO spr_action VALUES ('17974', '11', '32', '24');
INSERT INTO spr_action VALUES ('17974', '19', '36', '24');
INSERT INTO spr_action VALUES ('17974', '18', '36', '24');
INSERT INTO spr_action VALUES ('17974', '17', '23', '24');
INSERT INTO spr_action VALUES ('17974', '28', '3', '24');
INSERT INTO spr_action VALUES ('17975', '0', '24', '24');
INSERT INTO spr_action VALUES ('17975', '1', '24', '24');
INSERT INTO spr_action VALUES ('17975', '30', '28', '24');
INSERT INTO spr_action VALUES ('17975', '18', '21', '24');
INSERT INTO spr_action VALUES ('17976', '0', '36', '24');
INSERT INTO spr_action VALUES ('17976', '4', '16', '24');
INSERT INTO spr_action VALUES ('17976', '1', '36', '24');
INSERT INTO spr_action VALUES ('17976', '5', '42', '24');
INSERT INTO spr_action VALUES ('17976', '18', '48', '24');
INSERT INTO spr_action VALUES ('17976', '19', '72', '24');
INSERT INTO spr_action VALUES ('17976', '30', '50', '24');
INSERT INTO spr_action VALUES ('17977', '0', '24', '24');
INSERT INTO spr_action VALUES ('17977', '1', '10', '24');
INSERT INTO spr_action VALUES ('17977', '18', '32', '24');
INSERT INTO spr_action VALUES ('17978', '0', '6', '24');
INSERT INTO spr_action VALUES ('17978', '1', '20', '24');
INSERT INTO spr_action VALUES ('17978', '19', '43', '24');
INSERT INTO spr_action VALUES ('18001', '18', '17', '24');
INSERT INTO spr_action VALUES ('18001', '19', '19', '24');
INSERT INTO spr_action VALUES ('18001', '0', '20', '39');
INSERT INTO spr_action VALUES ('18001', '4', '20', '39');
INSERT INTO spr_action VALUES ('18001', '11', '20', '39');
INSERT INTO spr_action VALUES ('18001', '20', '20', '39');
INSERT INTO spr_action VALUES ('18001', '24', '20', '39');
INSERT INTO spr_action VALUES ('18001', '40', '20', '39');
INSERT INTO spr_action VALUES ('18001', '46', '20', '39');
INSERT INTO spr_action VALUES ('18001', '50', '20', '39');
INSERT INTO spr_action VALUES ('18001', '54', '20', '39');
INSERT INTO spr_action VALUES ('18001', '58', '20', '39');
INSERT INTO spr_action VALUES ('18001', '62', '20', '39');
INSERT INTO spr_action VALUES ('18001', '25', '20', '39');
INSERT INTO spr_action VALUES ('18001', '1', '35', '79');
INSERT INTO spr_action VALUES ('18001', '47', '35', '79');
INSERT INTO spr_action VALUES ('18001', '12', '85', '152');
INSERT INTO spr_action VALUES ('18001', '51', '85', '152');
INSERT INTO spr_action VALUES ('18001', '21', '190', '297');
INSERT INTO spr_action VALUES ('18001', '63', '190', '297');
INSERT INTO spr_action VALUES ('18001', '5', '150', '311');
INSERT INTO spr_action VALUES ('18001', '41', '150', '311');
INSERT INTO spr_action VALUES ('18001', '55', '150', '311');
INSERT INTO spr_action VALUES ('18001', '59', '150', '311');
INSERT INTO spr_action VALUES ('18621', '0', '70', '24');
INSERT INTO spr_action VALUES ('18621', '5', '2', '24');
INSERT INTO spr_action VALUES ('18621', '5', '2', '24');
INSERT INTO spr_action VALUES ('18621', '5', '4', '24');
INSERT INTO spr_action VALUES ('18621', '4', '0', '24');
INSERT INTO spr_action VALUES ('18621', '4', '2', '24');
INSERT INTO spr_action VALUES ('18621', '5', '4', '24');
INSERT INTO spr_action VALUES ('18621', '4', '0', '24');
INSERT INTO spr_action VALUES ('18621', '4', '2', '24');
INSERT INTO spr_action VALUES ('18621', '5', '4', '24');
INSERT INTO spr_action VALUES ('18621', '4', '0', '24');
INSERT INTO spr_action VALUES ('18621', '4', '2', '24');
INSERT INTO spr_action VALUES ('18621', '4', '2', '24');
INSERT INTO spr_action VALUE
1062 - Duplicate entry '18625-4' for key 'PRIMARY'
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '31', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '44', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '31', '24');
INSERT INTO spr_action VALUES ('18625', '5', '4', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '31', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '31', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '5', '4', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '31', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '15', '24');
INSERT INTO spr_action VALUES ('18625', '4', '31', '24');
INSERT INTO spr_action VALUES ('18625', '5', '4', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '5', '2', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '5', '2', '24');
INSERT INTO spr_action VALUES ('18625', '5', '4', '24');
INSERT INTO spr_action VALUES ('18625', '4', '0', '24');
INSERT INTO spr_action VALUES ('18625', '4', '2', '24');
INSERT INTO spr_action VALUES ('18629', '0', '16', '26');
INSERT INTO spr_action VALUES ('18629', '4', '16', '26');
INSERT INTO spr_action VALUES ('18629', '11', '16', '26');
INSERT INTO spr_action VALUES ('18629', '20', '16', '26');
INSERT INTO spr_action VALUES ('18629', '24', '16', '26');
INSERT INTO spr_action VALUES ('18629', '46', '16', '26');
INSERT INTO spr_action VALUES ('18629', '50', '16', '26');
INSERT INTO spr_action VALUES ('18629', '1', '17', '38');
INSERT INTO spr_action VALUES ('18629', '5', '18', '38');
INSERT INTO spr_action VALUES ('18629', '12', '21', '38');
INSERT INTO spr_action VALUES ('18629', '18', '16', '38');
INSERT INTO spr_action VALUES ('18629', '19', '18', '38');
INSERT INTO spr_action VALUES ('18629', '21', '23', '38');
INSERT INTO spr_action VALUES ('18629', '25', '20', '38');
INSERT INTO spr_action VALUES ('18629', '47', '17', '38');
INSERT INTO spr_action VALUES ('18629', '51', '21', '38');
INSERT INTO spr_action VALUES ('18633', '0', '70', '24');
INSERT INTO spr_action VALUES ('18633', '4', '2', '24');
INSERT INTO spr_action VALUES ('18633', '4', '2', '24');
INSERT INTO spr_action VALUES ('18633', '4', '15', '24');
INSERT INTO spr_action VALUES ('18633', '4', '40', '24');
INSERT INTO spr_action VALUES ('18633', '4', '2', '24');
INSERT INTO spr_action VALUES ('18633', '4', '15', '24');
INSERT INTO spr_action VALUES ('18633', '4', '40', '24');
INSERT INTO spr_action VALUES ('18633', '5', '4', '24');
INSERT INTO spr_action VALUES ('18633', '4', '0', '24');
INSERT INTO spr_action VALUES ('18633', '4', '2', '24');
INSERT INTO `spr_action
1062 - Duplicate entry '18637-4' for key 'PRIMARY'
INSERT INTO spr_action VALUES ('18637', '4', '24', '24');
INSERT INTO spr_action VALUES ('18637', '4', '26', '24');
INSERT INTO spr_action VALUES ('18637', '4', '9', '24');
INSERT INTO spr_action VALUES ('18637', '4', '0', '24');
INSERT INTO spr_action VALUES ('18637', '4', '2', '24');
INSERT INTO spr_action VALUES ('18637', '4', '15', '24');
INSERT INTO spr_action VALUES ('18637', '4', '24', '24');
INSERT INTO spr_action VALUES ('18637', '4', '26', '24');
INSERT INTO spr_action VALUES ('18637', '4', '9', '24');
INSERT INTO spr_action VALUES ('18637', '4', '0', '24');
INSERT INTO spr_action VALUES ('18637', '4', '2', '24');
INSERT INTO spr_action VALUES ('18637', '4', '15', '24');
INSERT INTO spr_action VALUES ('18637', '4', '24', '24');
INSERT INTO spr_action VALUES ('18637', '4', '26', '24');
INSERT INTO spr_action VALUES ('18637', '4', '9', '24');
INSERT INTO spr_action VALUES ('18637', '4', '0', '24');
INSERT INTO spr_action VALUES ('18637', '4', '2', '24');
INSERT INTO spr_action VALUES ('18637', '4', '15', '24');
INSERT INTO spr_action VALUES ('18637', '4', '27', '24');
INSERT INTO spr_action VALUES ('18637', '4', '29', '24');
INSERT INTO spr_action VALUES ('18637', '4', '2', '24');
INSERT INTO spr_action VALUES ('18637', '5', '2', '24');
INSERT INTO spr_action VALUES ('18637', '5', '4', '24');
INSERT INTO spr_action VALUES ('18637', '4', '0', '24');
INSERT INTO spr_action VALUES ('18637', '4', '2', '24');
INSERT INTO spr_action VALUES ('18637', '4', '0', '24');
INSERT INTO spr_action VALUES ('18637', '5', '2', '24');
INSERT INTO spr_action VALUES ('18637', '4', '2', '24');
INSERT INTO spr_action VALUES ('18637', '4', '0', '24');
INSERT INTO spr_action VALUES ('18637'

hulk888 發表於 2022-2-20 17:24

spr_action table 有值重複了檢查一下，看一下要留哪一個吧!

waisini 發表於 2022-2-20 21:40

你的編碼是跑步編碼，帶左右脚的，不支持

nickyjason 發表於 2022-2-22 16:42

感謝~~~~~~~~~~~已經修復

skatjdeo 發表於 2023-11-20 01:39

謝謝版主上傳好用工具

ABC7532147 發表於 2024-3-6 00:55

正好也卡在這 研究看看
頁: [1]
查看完整版本: 各位大大救命啊~~~導入spr_action出現錯誤~