Querry will nicht funzen

[[-Lee-]]

Hi leute , wenn ich versuche in meiner shop_item via querry was einzufügen

 Spoiler

INSERT INTO `shop_item` VALUES ('950', '14', '75012', '1', '');
INSERT INTO `shop_item` VALUES ('949', '14', '75011', '1', '');
INSERT INTO `shop_item` VALUES ('948', '14', '75010', '1', '');
INSERT INTO `shop_item` VALUES ('947', '14', '75009', '1', '');
INSERT INTO `shop_item` VALUES ('946', '14', '75008', '1', '');
INSERT INTO `shop_item` VALUES ('945', '14', '75007', '1', '');
INSERT INTO `shop_item` VALUES ('944', '14', '75006', '1', '');
INSERT INTO `shop_item` VALUES ('943', '14', '75005', '1', '');
INSERT INTO `shop_item` VALUES ('942', '14', '75004', '1', '');
INSERT INTO `shop_item` VALUES ('941', '14', '75003', '1', '');
INSERT INTO `shop_item` VALUES ('940', '14', '75002', '1', '');
INSERT INTO `shop_item` VALUES ('939', '14', '75001', '1', '');
INSERT INTO `shop_item` VALUES ('938', '14', '50420', '1', '');
INSERT INTO `shop_item` VALUES ('937', '14', '50419', '1', '');
INSERT INTO `shop_item` VALUES ('936', '14', '50418', '1', '');
INSERT INTO `shop_item` VALUES ('935', '14', '50417', '1', '');
INSERT INTO `shop_item` VALUES ('934', '14', '50416', '1', '');
INSERT INTO `shop_item` VALUES ('933', '13', '74012', '1', '');
INSERT INTO `shop_item` VALUES ('932', '13', '74011', '1', '');
INSERT INTO `shop_item` VALUES ('931', '13', '74010', '1', '');
INSERT INTO `shop_item` VALUES ('930', '13', '74009', '1', '');
INSERT INTO `shop_item` VALUES ('929', '13', '74008', '1', '');
INSERT INTO `shop_item` VALUES ('928', '13', '74007', '1', '');
INSERT INTO `shop_item` VALUES ('927', '13', '74006', '1', '');
INSERT INTO `shop_item` VALUES ('926', '13', '74005', '1', '');
INSERT INTO `shop_item` VALUES ('925', '13', '74004', '1', '');
INSERT INTO `shop_item` VALUES ('924', '13', '74003', '1', '');
INSERT INTO `shop_item` VALUES ('923', '13', '74002', '1', '');
INSERT INTO `shop_item` VALUES ('922', '13', '74001', '1', '');
INSERT INTO `shop_item` VALUES ('921', '13', '50405', '1', '');
INSERT INTO `shop_item` VALUES ('920', '13', '50404', '1', '');
INSERT INTO `shop_item` VALUES ('919', '13', '50403', '1', '');
INSERT INTO `shop_item` VALUES ('918', '13', '50402', '1', '');
INSERT INTO `shop_item` VALUES ('917', '13', '50401', '1', '');
INSERT INTO `shop_item` VALUES ('1333', '71', '74762', '1', '');
INSERT INTO `shop_item` VALUES ('1332', '71', '74761', '1', '');
INSERT INTO `shop_item` VALUES ('1331', '71', '74760', '1', '');
INSERT INTO `shop_item` VALUES ('1330', '71', '74759', '1', '');
INSERT INTO `shop_item` VALUES ('1329', '71', '74758', '1', '');
INSERT INTO `shop_item` VALUES ('1328', '71', '74757', '1', '');
INSERT INTO `shop_item` VALUES ('1327', '71', '74756', '1', '');
INSERT INTO `shop_item` VALUES ('1326', '71', '74755', '1', '');
INSERT INTO `shop_item` VALUES ('1325', '71', '74754', '1', '');
INSERT INTO `shop_item` VALUES ('1324', '71', '74753', '1', '');
INSERT INTO `shop_item` VALUES ('1323', '71', '74752', '1', '');
INSERT INTO `shop_item` VALUES ('1322', '71', '74751', '1', '');
INSERT INTO `shop_item` VALUES ('1321', '71', '50496', '1', '');
INSERT INTO `shop_item` VALUES ('1320', '71', '50495', '1', '');
INSERT INTO `shop_item` VALUES ('1319', '71', '50494', '1', '');
INSERT INTO `shop_item` VALUES ('1318', '71', '50493', '1', '');
INSERT INTO `shop_item` VALUES ('1317', '71', '50492', '1', '');
INSERT INTO `shop_item` VALUES ('1316', '71', '50491', '1', '');
INSERT INTO `shop_item` VALUES ('1315', '72', '75612', '1', '');
INSERT INTO `shop_item` VALUES ('1314', '72', '75611', '1', '');
INSERT INTO `shop_item` VALUES ('1313', '72', '75610', '1', '');
INSERT INTO `shop_item` VALUES ('1312', '72', '75609', '1', '');
INSERT INTO `shop_item` VALUES ('1311', '72', '75608', '1', '');
INSERT INTO `shop_item` VALUES ('1310', '72', '75607', '1', '');
INSERT INTO `shop_item` VALUES ('1309', '72', '75606', '1', '');
INSERT INTO `shop_item` VALUES ('1308', '72', '75605', '1', '');
INSERT INTO `shop_item` VALUES ('1307', '72', '75604', '1', '');
INSERT INTO `shop_item` VALUES ('1306', '72', '75603', '1', '');
INSERT INTO `shop_item` VALUES ('1305', '72', '75602', '1', '');
INSERT INTO `shop_item` VALUES ('1304', '72', '75601', '1', '');
INSERT INTO `shop_item` VALUES ('1303', '72', '50511', '1', '');
INSERT INTO `shop_item` VALUES ('1302', '72', '50510', '1', '');
INSERT INTO `shop_item` VALUES ('1301', '72', '50509', '1', '');
INSERT INTO `shop_item` VALUES ('1300', '72', '50508', '1', '');
INSERT INTO `shop_item` VALUES ('1299', '72', '50507', '1', '');
INSERT INTO `shop_item` VALUES ('1298', '72', '50506', '1', '');
INSERT INTO `shop_item` VALUES ('1297', '70', '75412', '1', '');
INSERT INTO `shop_item` VALUES ('1296', '70', '75411', '1', '');
INSERT INTO `shop_item` VALUES ('1295', '70', '75410', '1', '');
INSERT INTO `shop_item` VALUES ('1294', '70', '75409', '1', '');
INSERT INTO `shop_item` VALUES ('1293', '70', '75408', '1', '');
INSERT INTO `shop_item` VALUES ('1292', '70', '75407', '1', '');
INSERT INTO `shop_item` VALUES ('1291', '70', '75406', '1', '');
INSERT INTO `shop_item` VALUES ('1290', '70', '75405', '1', '');
INSERT INTO `shop_item` VALUES ('1289', '70', '75404', '1', '');
INSERT INTO `shop_item` VALUES ('1288', '70', '75403', '1', '');
INSERT INTO `shop_item` VALUES ('1287', '70', '75402', '1', '');
INSERT INTO `shop_item` VALUES ('1286', '70', '75401', '1', '');
INSERT INTO `shop_item` VALUES ('1285', '70', '50481', '1', '');
INSERT INTO `shop_item` VALUES ('1284', '70', '50480', '1', '');
INSERT INTO `shop_item` VALUES ('1283', '70', '50479', '1', '');
INSERT INTO `shop_item` VALUES ('1282', '70', '50478', '1', '');
INSERT INTO `shop_item` VALUES ('1281', '70', '50477', '1', '');
INSERT INTO `shop_item` VALUES ('1280', '70', '50476', '1', '');
INSERT INTO `shop_item` VALUES ('1279', '69', '74512', '1', '');
INSERT INTO `shop_item` VALUES ('1278', '69', '74511', '1', '');
INSERT INTO `shop_item` VALUES ('1277', '69', '74510', '1', '');
INSERT INTO `shop_item` VALUES ('1276', '69', '74509', '1', '');
INSERT INTO `shop_item` VALUES ('1275', '69', '74508', '1', '');
INSERT INTO `shop_item` VALUES ('1274', '69', '74507', '1', '');
INSERT INTO `shop_item` VALUES ('1273', '69', '74506', '1', '');
INSERT INTO `shop_item` VALUES ('1272', '69', '74505', '1', '');
INSERT INTO `shop_item` VALUES ('1271', '69', '74504', '1', '');
INSERT INTO `shop_item` VALUES ('1270', '69', '74503', '1', '');
INSERT INTO `shop_item` VALUES ('1269', '69', '74502', '1', '');
INSERT INTO `shop_item` VALUES ('1268', '69', '74501', '1', '');
INSERT INTO `shop_item` VALUES ('1267', '69', '50466', '1', '');
INSERT INTO `shop_item` VALUES ('1266', '69', '50465', '1', '');
INSERT INTO `shop_item` VALUES ('1265', '69', '50464', '1', '');
INSERT INTO `shop_item` VALUES ('1264', '69', '50463', '1', '');
INSERT INTO `shop_item` VALUES ('1263', '69', '50462', '1', '');
INSERT INTO `shop_item` VALUES ('1262', '69', '50461', '1', '');
INSERT INTO `shop_item` VALUES ('1261', '68', '74262', '1', '');
INSERT INTO `shop_item` VALUES ('1260', '68', '74261', '1', '');
INSERT INTO `shop_item` VALUES ('1259', '68', '74260', '1', '');
INSERT INTO `shop_item` VALUES ('1258', '68', '74259', '1', '');
INSERT INTO `shop_item` VALUES ('1257', '68', '74258', '1', '');
INSERT INTO `shop_item` VALUES ('1256', '68', '74257', '1', '');
INSERT INTO `shop_item` VALUES ('1255', '68', '74256', '1', '');
INSERT INTO `shop_item` VALUES ('1254', '68', '74255', '1', '');
INSERT INTO `shop_item` VALUES ('1253', '68', '74254', '1', '');
INSERT INTO `shop_item` VALUES ('1252', '68', '74253', '1', '');
INSERT INTO `shop_item` VALUES ('1251', '68', '74252', '1', '');
INSERT INTO `shop_item` VALUES ('1250', '68', '74251', '1', '');
INSERT INTO `shop_item` VALUES ('1249', '68', '50450', '1', '');
INSERT INTO `shop_item` VALUES ('1248', '68', '50449', '1', '');
INSERT INTO `shop_item` VALUES ('1247', '68', '50448', '1', '');
INSERT INTO `shop_item` VALUES ('1246', '68', '50447', '1', '');
INSERT INTO `shop_item` VALUES ('1245', '68', '50446', '1', '');
INSERT INTO `shop_item` VALUES ('1244', '67', '75212', '1', '');
INSERT INTO `shop_item` VALUES ('1243', '67', '75211', '1', '');
INSERT INTO `shop_item` VALUES ('1242', '67', '75210', '1', '');
INSERT INTO `shop_item` VALUES ('1241', '67', '75209', '1', '');
INSERT INTO `shop_item` VALUES ('1240', '67', '75208', '1', '');
INSERT INTO `shop_item` VALUES ('1239', '67', '75207', '1', '');
INSERT INTO `shop_item` VALUES ('1238', '67', '75206', '1', '');
INSERT INTO `shop_item` VALUES ('1237', '67', '75205', '1', '');
INSERT INTO `shop_item` VALUES ('1236', '67', '75204', '1', '');
INSERT INTO `shop_item` VALUES ('1235', '67', '75203', '1', '');
INSERT INTO `shop_item` VALUES ('1234', '67', '75202', '1', '');
INSERT INTO `shop_item` VALUES ('1233', '67', '75201', '1', '');
INSERT INTO `shop_item` VALUES ('1232', '67', '50435', '1', '');
INSERT INTO `shop_item` VALUES ('1231', '67', '50434', '1', '');
INSERT INTO `shop_item` VALUES ('1230', '67', '50433', '1', '');
INSERT INTO `shop_item` VALUES ('1229', '67', '50432', '1', '');
INSERT INTO `shop_item` VALUES ('1228', '67', '50431', '1', '');
INSERT INTO `shop_item` VALUES ('1227', '66', '75012', '1', '');
INSERT INTO `shop_item` VALUES ('1226', '66', '75011', '1', '');
INSERT INTO `shop_item` VALUES ('1225', '66', '75010', '1', '');
INSERT INTO `shop_item` VALUES ('1224', '66', '75009', '1', '');
INSERT INTO `shop_item` VALUES ('1223', '66', '75008', '1', '');
INSERT INTO `shop_item` VALUES ('1222', '66', '75007', '1', '');
INSERT INTO `shop_item` VALUES ('1221', '66', '75006', '1', '');
INSERT INTO `shop_item` VALUES ('1220', '66', '75005', '1', '');
INSERT INTO `shop_item` VALUES ('1219', '66', '75004', '1', '');
INSERT INTO `shop_item` VALUES ('1218', '66', '75003', '1', '');
INSERT INTO `shop_item` VALUES ('1217', '66', '75002', '1', '');
INSERT INTO `shop_item` VALUES ('1216', '66', '75001', '1', '');
INSERT INTO `shop_item` VALUES ('1215', '66', '50420', '1', '');
INSERT INTO `shop_item` VALUES ('1214', '66', '50419', '1', '');
INSERT INTO `shop_item` VALUES ('1213', '66', '50418', '1', '');
INSERT INTO `shop_item` VALUES ('1212', '66', '50417', '1', '');
INSERT INTO `shop_item` VALUES ('1211', '66', '50416', '1', '');
INSERT INTO `shop_item` VALUES ('1210', '65', '74012', '1', '');
INSERT INTO `shop_item` VALUES ('1209', '65', '74011', '1', '');
INSERT INTO `shop_item` VALUES ('1208', '65', '74010', '1', '');
INSERT INTO `shop_item` VALUES ('1207', '65', '74009', '1', '');
INSERT INTO `shop_item` VALUES ('1206', '65', '74008', '1', '');
INSERT INTO `shop_item` VALUES ('1205', '65', '74007', '1', '');
INSERT INTO `shop_item` VALUES ('1204', '65', '74006', '1', '');
INSERT INTO `shop_item` VALUES ('1203', '65', '74005', '1', '');
INSERT INTO `shop_item` VALUES ('1202', '65', '74004', '1', '');
INSERT INTO `shop_item` VALUES ('1201', '65', '74003', '1', '');
INSERT INTO `shop_item` VALUES ('1200', '65', '74002', '1', '');
INSERT INTO `shop_item` VALUES ('1199', '65', '74001', '1', '');
INSERT INTO `shop_item` VALUES ('1198', '65', '50405', '1', '');
INSERT INTO `shop_item` VALUES ('1197', '65', '50404', '1', '');
INSERT INTO `shop_item` VALUES ('1196', '65', '50403', '1', '');
INSERT INTO `shop_item` VALUES ('1195', '65', '50402', '1', '');
INSERT INTO `shop_item` VALUES ('1194', '65', '50401', '1', '');
INSERT INTO `shop_item` VALUES ('1193', '63', '74762', '1', '');
INSERT INTO `shop_item` VALUES ('1192', '63', '74761', '1', '');
INSERT INTO `shop_item` VALUES ('1191', '63', '74760', '1', '');
INSERT INTO `shop_item` VALUES ('1190', '63', '74759', '1', '');
INSERT INTO `shop_item` VALUES ('1189', '63', '74758', '1', '');
INSERT INTO `shop_item` VALUES ('1188', '63', '74757', '1', '');
INSERT INTO `shop_item` VALUES ('1187', '63', '74756', '1', '');
INSERT INTO `shop_item` VALUES ('1186', '63', '74755', '1', '');
INSERT INTO `shop_item` VALUES ('1185', '63', '74754', '1', '');
INSERT INTO `shop_item` VALUES ('1184', '63', '74753', '1', '');
INSERT INTO `shop_item` VALUES ('1183', '63', '74752', '1', '');
INSERT INTO `shop_item` VALUES ('1182', '63', '74751', '1', '');
INSERT INTO `shop_item` VALUES ('1181', '63', '50496', '1', '');
INSERT INTO `shop_item` VALUES ('1180', '63', '50495', '1', '');
INSERT INTO `shop_item` VALUES ('1179', '63', '50494', '1', '');
INSERT INTO `shop_item` VALUES ('1178', '63', '50493', '1', '');
INSERT INTO `shop_item` VALUES ('1177', '63', '50492', '1', '');
INSERT INTO `shop_item` VALUES ('1176', '63', '50491', '1', '');
INSERT INTO `shop_item` VALUES ('1175', '64', '75612', '1', '');
INSERT INTO `shop_item` VALUES ('1174', '64', '75611', '1', '');
INSERT INTO `shop_item` VALUES ('1173', '64', '75610', '1', '');
INSERT INTO `shop_item` VALUES ('1172', '64', '75609', '1', '');
INSERT INTO `shop_item` VALUES ('1171', '64', '75608', '1', '');
INSERT INTO `shop_item` VALUES ('1170', '64', '75607', '1', '');
INSERT INTO `shop_item` VALUES ('1169', '64', '75606', '1', '');
INSERT INTO `shop_item` VALUES ('1168', '64', '75605', '1', '');
INSERT INTO `shop_item` VALUES ('1167', '64', '75604', '1', '');
INSERT INTO `shop_item` VALUES ('1166', '64', '75603', '1', '');
INSERT INTO `shop_item` VALUES ('1165', '64', '75602', '1', '');
INSERT INTO `shop_item` VALUES ('1164', '64', '75601', '1', '');
INSERT INTO `shop_item` VALUES ('1163', '64', '50511', '1', '');
INSERT INTO `shop_item` VALUES ('1162', '64', '50510', '1', '');
INSERT INTO `shop_item` VALUES ('1161', '64', '50509', '1', '');
INSERT INTO `shop_item` VALUES ('1160', '64', '50508', '1', '');
INSERT INTO `shop_item` VALUES ('1159', '64', '50507', '1', '');
INSERT INTO `shop_item` VALUES ('1158', '64', '50506', '1', '');
INSERT INTO `shop_item` VALUES ('1157', '62', '75412', '1', '');
INSERT INTO `shop_item` VALUES ('1156', '62', '75411', '1', '');
INSERT INTO `shop_item` VALUES ('1155', '62', '75410', '1', '');
INSERT INTO `shop_item` VALUES ('1154', '62', '75409', '1', '');
INSERT INTO `shop_item` VALUES ('1153', '62', '75408', '1', '');
INSERT INTO `shop_item` VALUES ('1152', '62', '75407', '1', '');
INSERT INTO `shop_item` VALUES ('1151', '62', '75406', '1', '');
INSERT INTO `shop_item` VALUES ('1150', '62', '75405', '1', '');
INSERT INTO `shop_item` VALUES ('1149', '62', '75404', '1', '');
INSERT INTO `shop_item` VALUES ('1148', '62', '75403', '1', '');
INSERT INTO `shop_item` VALUES ('1147', '62', '75402', '1', '');
INSERT INTO `shop_item` VALUES ('1146', '62', '75401', '1', '');
INSERT INTO `shop_item` VALUES ('1145', '62', '50481', '1', '');
INSERT INTO `shop_item` VALUES ('1144', '62', '50480', '1', '');
INSERT INTO `shop_item` VALUES ('1143', '62', '50479', '1', '');
INSERT INTO `shop_item` VALUES ('1142', '62', '50478', '1', '');
INSERT INTO `shop_item` VALUES ('1141', '62', '50477', '1', '');
INSERT INTO `shop_item` VALUES ('1140', '62', '50476', '1', '');
INSERT INTO `shop_item` VALUES ('1139', '61', '74512', '1', '');
INSERT INTO `shop_item` VALUES ('1138', '61', '74511', '1', '');
INSERT INTO `shop_item` VALUES ('1137', '61', '74510', '1', '');
INSERT INTO `shop_item` VALUES ('1136', '61', '74509', '1', '');
INSERT INTO `shop_item` VALUES ('1135', '61', '74508', '1', '');
INSERT INTO `shop_item` VALUES ('1134', '61', '74507', '1', '');
INSERT INTO `shop_item` VALUES ('1133', '61', '74506', '1', '');
INSERT INTO `shop_item` VALUES ('1132', '61', '74505', '1', '');
INSERT INTO `shop_item` VALUES ('1131', '61', '74504', '1', '');
INSERT INTO `shop_item` VALUES ('1130', '61', '74503', '1', '');
INSERT INTO `shop_item` VALUES ('1129', '61', '74502', '1', '');
INSERT INTO `shop_item` VALUES ('1128', '61', '74501', '1', '');
INSERT INTO `shop_item` VALUES ('1127', '61', '50466', '1', '');
INSERT INTO `shop_item` VALUES ('1126', '61', '50465', '1', '');
INSERT INTO `shop_item` VALUES ('1125', '61', '50464', '1', '');
INSERT INTO `shop_item` VALUES ('1124', '61', '50463', '1', '');
INSERT INTO `shop_item` VALUES ('1123', '61', '50462', '1', '');
INSERT INTO `shop_item` VALUES ('1122', '61', '50461', '1', '');
INSERT INTO `shop_item` VALUES ('1121', '60', '74262', '1', '');
INSERT INTO `shop_item` VALUES ('1120', '60', '74261', '1', '');
INSERT INTO `shop_item` VALUES ('1119', '60', '74260', '1', '');
INSERT INTO `shop_item` VALUES ('1118', '60', '74259', '1', '');
INSERT INTO `shop_item` VALUES ('1117', '60', '74258', '1', '');
INSERT INTO `shop_item` VALUES ('1116', '60', '74257', '1', '');
INSERT INTO `shop_item` VALUES ('1115', '60', '74256', '1', '');
INSERT INTO `shop_item` VALUES ('1114', '60', '74255', '1', '');
INSERT INTO `shop_item` VALUES ('1113', '60', '74254', '1', '');
INSERT INTO `shop_item` VALUES ('1112', '60', '74253', '1', '');
INSERT INTO `shop_item` VALUES ('1111', '60', '74252', '1', '');
INSERT INTO `shop_item` VALUES ('1110', '60', '74251', '1', '');
INSERT INTO `shop_item` VALUES ('1109', '60', '50450', '1', '');
INSERT INTO `shop_item` VALUES ('1108', '60', '50449', '1', '');
INSERT INTO `shop_item` VALUES ('1107', '60', '50448', '1', '');
INSERT INTO `shop_item` VALUES ('1106', '60', '50447', '1', '');
INSERT INTO `shop_item` VALUES ('1105', '60', '50446', '1', '');
INSERT INTO `shop_item` VALUES ('1104', '59', '75212', '1', '');
INSERT INTO `shop_item` VALUES ('1103', '59', '75211', '1', '');
INSERT INTO `shop_item` VALUES ('1102', '59', '75210', '1', '');
INSERT INTO `shop_item` VALUES ('1101', '59', '75209', '1', '');
INSERT INTO `shop_item` VALUES ('1100', '59', '75208', '1', '');
INSERT INTO `shop_item` VALUES ('1099', '59', '75207', '1', '');
INSERT INTO `shop_item` VALUES ('1098', '59', '75206', '1', '');
INSERT INTO `shop_item` VALUES ('1097', '59', '75205', '1', '');
INSERT INTO `shop_item` VALUES ('1096', '59', '75204', '1', '');
INSERT INTO `shop_item` VALUES ('1095', '59', '75203', '1', '');
INSERT INTO `shop_item` VALUES ('1094', '59', '75202', '1', '');
INSERT INTO `shop_item` VALUES ('1093', '59', '75201', '1', '');
INSERT INTO `shop_item` VALUES ('1092', '59', '50435', '1', '');
INSERT INTO `shop_item` VALUES ('1091', '59', '50434', '1', '');
INSERT INTO `shop_item` VALUES ('1090', '59', '50433', '1', '');
INSERT INTO `shop_item` VALUES ('1089', '59', '50432', '1', '');
INSERT INTO `shop_item` VALUES ('1088', '59', '50431', '1', '');
INSERT INTO `shop_item` VALUES ('1087', '58', '75012', '1', '');
INSERT INTO `shop_item` VALUES ('1086', '58', '75011', '1', '');
INSERT INTO `shop_item` VALUES ('1085', '58', '75010', '1', '');
INSERT INTO `shop_item` VALUES ('1084', '58', '75009', '1', '');
INSERT INTO `shop_item` VALUES ('1083', '58', '75008', '1', '');
INSERT INTO `shop_item` VALUES ('1082', '58', '75007', '1', '');
INSERT INTO `shop_item` VALUES ('1081', '58', '75006', '1', '');
INSERT INTO `shop_item` VALUES ('1080', '58', '75005', '1', '');
INSERT INTO `shop_item` VALUES ('1079', '58', '75004', '1', '');
INSERT INTO `shop_item` VALUES ('1078', '58', '75003', '1', '');
INSERT INTO `shop_item` VALUES ('1077', '58', '75002', '1', '');
INSERT INTO `shop_item` VALUES ('1076', '58', '75001', '1', '');
INSERT INTO `shop_item` VALUES ('1075', '58', '50420', '1', '');
INSERT INTO `shop_item` VALUES ('1074', '58', '50419', '1', '');
INSERT INTO `shop_item` VALUES ('1073', '58', '50418', '1', '');
INSERT INTO `shop_item` VALUES ('1072', '58', '50417', '1', '');
INSERT INTO `shop_item` VALUES ('1071', '58', '50416', '1', '');
INSERT INTO `shop_item` VALUES ('1070', '57', '74012', '1', '');
INSERT INTO `shop_item` VALUES ('1069', '57', '74011', '1', '');
INSERT INTO `shop_item` VALUES ('1068', '57', '74010', '1', '');
INSERT INTO `shop_item` VALUES ('1067', '57', '74009', '1', '');
INSERT INTO `shop_item` VALUES ('1066', '57', '74008', '1', '');
INSERT INTO `shop_item` VALUES ('1065', '57', '74007', '1', '');
INSERT INTO `shop_item` VALUES ('1064', '57', '74006', '1', '');
INSERT INTO `shop_item` VALUES ('1063', '57', '74005', '1', '');
INSERT INTO `shop_item` VALUES ('1062', '57', '74004', '1', '');
INSERT INTO `shop_item` VALUES ('1061', '57', '74003', '1', '');
INSERT INTO `shop_item` VALUES ('1060', '57', '74002', '1', '');
INSERT INTO `shop_item` VALUES ('1059', '57', '74001', '1', '');
INSERT INTO `shop_item` VALUES ('1058', '57', '50405', '1', '');
INSERT INTO `shop_item` VALUES ('1057', '57', '50404', '1', '');
INSERT INTO `shop_item` VALUES ('1056', '57', '50403', '1', '');
INSERT INTO `shop_item` VALUES ('1055', '57', '50402', '1', '');
INSERT INTO `shop_item` VALUES ('1054', '57', '50401', '1', '');
INSERT INTO `shop_item` VALUES ('1053', '55', '75612', '1', '');
INSERT INTO `shop_item` VALUES ('1052', '55', '75611', '1', '');
INSERT INTO `shop_item` VALUES ('1051', '55', '75610', '1', '');
INSERT INTO `shop_item` VALUES ('1050', '55', '75609', '1', '');
INSERT INTO `shop_item` VALUES ('1049', '55', '75608', '1', '');
INSERT INTO `shop_item` VALUES ('1048', '55', '75607', '1', '');
INSERT INTO `shop_item` VALUES ('1047', '55', '75606', '1', '');
INSERT INTO `shop_item` VALUES ('1046', '55', '75605', '1', '');
INSERT INTO `shop_item` VALUES ('1045', '55', '75604', '1', '');
INSERT INTO `shop_item` VALUES ('1044', '55', '75603', '1', '');
INSERT INTO `shop_item` VALUES ('1043', '55', '75602', '1', '');
INSERT INTO `shop_item` VALUES ('1042', '55', '75601', '1', '');
INSERT INTO `shop_item` VALUES ('1041', '55', '50496', '1', '');
INSERT INTO `shop_item` VALUES ('1040', '55', '50495', '1', '');
INSERT INTO `shop_item` VALUES ('1039', '55', '50494', '1', '');
INSERT INTO `shop_item` VALUES ('1038', '55', '50493', '1', '');
INSERT INTO `shop_item` VALUES ('1037', '55', '50492', '1', '');
INSERT INTO `shop_item` VALUES ('1036', '55', '50491', '1', '');
INSERT INTO `shop_item` VALUES ('1035', '56', '74762', '1', '');
INSERT INTO `shop_item` VALUES ('1034', '56', '74758', '1', '');
INSERT INTO `shop_item` VALUES ('1033', '56', '74757', '1', '');
INSERT INTO `shop_item` VALUES ('1032', '56', '74756', '1', '');
INSERT INTO `shop_item` VALUES ('1031', '56', '74755', '1', '');
INSERT INTO `shop_item` VALUES ('1030', '56', '74754', '1', '');
INSERT INTO `shop_item` VALUES ('1029', '56', '74753', '1', '');
INSERT INTO `shop_item` VALUES ('1028', '56', '74752', '1', '');
INSERT INTO `shop_item` VALUES ('1027', '56', '74751', '1', '');
INSERT INTO `shop_item` VALUES ('1026', '56', '50511', '1', '');
INSERT INTO `shop_item` VALUES ('1025', '56', '50510', '1', '');
INSERT INTO `shop_item` VALUES ('1024', '56', '50509', '1', '');
INSERT INTO `shop_item` VALUES ('1023', '56', '50508', '1', '');
INSERT INTO `shop_item` VALUES ('1022', '56', '50507', '1', '');
INSERT INTO `shop_item` VALUES ('1021', '56', '50506', '1', '');
INSERT INTO `shop_item` VALUES ('1020', '54', '75412', '1', '');
INSERT INTO `shop_item` VALUES ('1019', '54', '75411', '1', '');
INSERT INTO `shop_item` VALUES ('1018', '54', '75410', '1', '');
INSERT INTO `shop_item` VALUES ('1017', '54', '75409', '1', '');
INSERT INTO `shop_item` VALUES ('1016', '54', '75408', '1', '');
INSERT INTO `shop_item` VALUES ('1015', '54', '75407', '1', '');
INSERT INTO `shop_item` VALUES ('1014', '54', '74506', '1', '');
INSERT INTO `shop_item` VALUES ('1013', '54', '75405', '1', '');
INSERT INTO `shop_item` VALUES ('1012', '54', '75404', '1', '');
INSERT INTO `shop_item` VALUES ('1011', '54', '75403', '1', '');
INSERT INTO `shop_item` VALUES ('1010', '54', '75402', '1', '');
INSERT INTO `shop_item` VALUES ('1009', '54', '75401', '1', '');
INSERT INTO `shop_item` VALUES ('1008', '54', '50481', '1', '');
INSERT INTO `shop_item` VALUES ('1007', '54', '50480', '1', '');
INSERT INTO `shop_item` VALUES ('1006', '54', '50479', '1', '');
INSERT INTO `shop_item` VALUES ('1005', '54', '50478', '1', '');
INSERT INTO `shop_item` VALUES ('1004', '54', '50477', '1', '');
INSERT INTO `shop_item` VALUES ('1003', '54', '50476', '1', '');
INSERT INTO `shop_item` VALUES ('1002', '53', '74512', '1', '');
INSERT INTO `shop_item` VALUES ('1001', '53', '74511', '1', '');
INSERT INTO `shop_item` VALUES ('1000', '53', '74510', '1', '');
INSERT INTO `shop_item` VALUES ('999', '53', '74509', '1', '');
INSERT INTO `shop_item` VALUES ('998', '53', '74508', '1', '');
INSERT INTO `shop_item` VALUES ('997', '53', '74507', '1', '');
INSERT INTO `shop_item` VALUES ('996', '53', '74506', '1', '');
INSERT INTO `shop_item` VALUES ('995', '53', '74505', '1', '');
INSERT INTO `shop_item` VALUES ('994', '53', '74504', '1', '');
INSERT INTO `shop_item` VALUES ('993', '53', '74503', '1', '');
INSERT INTO `shop_item` VALUES ('992', '53', '74502', '1', '');
INSERT INTO `shop_item` VALUES ('991', '53', '74501', '1', '');
INSERT INTO `shop_item` VALUES ('990', '53', '50466', '1', '');
INSERT INTO `shop_item` VALUES ('989', '53', '50465', '1', '');
INSERT INTO `shop_item` VALUES ('988', '53', '50464', '1', '');
INSERT INTO `shop_item` VALUES ('987', '53', '50463', '1', '');
INSERT INTO `shop_item` VALUES ('986', '53', '50462', '1', '');
INSERT INTO `shop_item` VALUES ('985', '53', '50461', '1', '');
INSERT INTO `shop_item` VALUES ('984', '52', '74262', '1', '');
INSERT INTO `shop_item` VALUES ('983', '52', '74261', '1', '');
INSERT INTO `shop_item` VALUES ('982', '52', '74260', '1', '');
INSERT INTO `shop_item` VALUES ('981', '52', '74259', '1', '');
INSERT INTO `shop_item` VALUES ('980', '52', '74258', '1', '');
INSERT INTO `shop_item` VALUES ('979', '52', '74257', '1', '');
INSERT INTO `shop_item` VALUES ('978', '52', '74256', '1', '');
INSERT INTO `shop_item` VALUES ('977', '52', '74255', '1', '');
INSERT INTO `shop_item` VALUES ('976', '52', '74254', '1', '');
INSERT INTO `shop_item` VALUES ('975', '52', '74253', '1', '');
INSERT INTO `shop_item` VALUES ('974', '52', '74252', '1', '');
INSERT INTO `shop_item` VALUES ('973', '52', '74251', '1', '');
INSERT INTO `shop_item` VALUES ('972', '52', '50450', '1', '');
INSERT INTO `shop_item` VALUES ('971', '52', '50449', '1', '');
INSERT INTO `shop_item` VALUES ('970', '52', '50448', '1', '');
INSERT INTO `shop_item` VALUES ('969', '52', '50447', '1', '');
INSERT INTO `shop_item` VALUES ('968', '52', '50446', '1', '');
INSERT INTO `shop_item` VALUES ('967', '51', '75212', '1', '');
INSERT INTO `shop_item` VALUES ('966', '51', '75211', '1', '');
INSERT INTO `shop_item` VALUES ('965', '51', '75210', '1', '');
INSERT INTO `shop_item` VALUES ('964', '51', '75209', '1', '');
INSERT INTO `shop_item` VALUES ('963', '51', '75208', '1', '');
INSERT INTO `shop_item` VALUES ('962', '51', '75207', '1', '');
INSERT INTO `shop_item` VALUES ('961', '51', '75206', '1', '');
INSERT INTO `shop_item` VALUES ('960', '51', '75205', '1', '');
INSERT INTO `shop_item` VALUES ('959', '51', '75204', '1', '');
INSERT INTO `shop_item` VALUES ('958', '51', '75203', '1', '');
INSERT INTO `shop_item` VALUES ('957', '51', '75202', '1', '');
INSERT INTO `shop_item` VALUES ('956', '51', '75201', '1', '');
INSERT INTO `shop_item` VALUES ('955', '51', '50435', '1', '');
INSERT INTO `shop_item` VALUES ('954', '51', '50434', '1', '');
INSERT INTO `shop_item` VALUES ('953', '51', '50433', '1', '');
INSERT INTO `shop_item` VALUES ('952', '51', '50432', '1', '');
INSERT INTO `shop_item` VALUES ('951', '51', '50431', '1', '');

dann kommt IMMER diese

PHP Code:

[SQL] 
INSERT INTO `shop_item` VALUES ('949', '14', '75011', '1', '');
[Err] 1136 - Column count doesn't match value count at row 1 


kann mir einer sagen was ich bzw was an den querrys falsch ist?

[4C1D.]

Wenn man Englisch kann: Spaltenzählung bringt Wertzählung nicht an Reihe 1 zusammen.
Würde dir mal empfehlen zur Schule zu gehen statt am PC zu sitzen.
Wenn das nicht hilft translator ftw

[αίίR7 :3]

Originally Posted by α¢ι∂

Wenn man Englisch kann: Spaltenzählung bringt Wertzählung nicht an Reihe 1 zusammen.
Würde dir mal empfehlen zur Schule zu gehen statt am PC zu sitzen.
Wenn das nicht hilft translator ftw

er sucht hilfe und keine provozierung, bevor du hier anfängst wieder leute zu dissn geh du lieber raus, wer hocktn schon um 8 am pc? (bin gerade aufgestanden um Mails zu checken)

@Lee, ich helf dir später wennu icq on bist.

[4C1D.]

Originally Posted by MSI.aiiR7

er sucht hilfe und keine provozierung, bevor du hier anfängst wieder leute zu dissn geh du lieber raus, wer hocktn schon um 8 am pc? (bin gerade aufgestanden um Mails zu checken)

@Lee, ich helf dir später wennu icq on bist.

Ich hab grad Schule Informatik

€: Haste ne Email bei Epvp?

[>¿²²²²²¿<]

Hmm....Bei den Querys fehlt noch etwas... Hinter dem "..;" Gehört noch etwas ...

[.KKS]

Erstellt du immer neue Zeilen oder bearbeitest die alten?

[αίίR7 :3]

Originally Posted by Blackiii...x3

Erstellt du immer neue Zeilen oder bearbeitest die alten?

er will die vorhanden queries nur in die tabelle dumpen

[hen!]

Du hast das Tool benutzt welches die Spalten del und name oder so mit einfügt.

Die tatsächliche shop_item-Tabelle besitzt aber nur 3 spalten.

Du musst entweder die Spalten ergänzen, oder sie aus den querys nehmen!

[[-Lee-]]

haber garkein toll benutzt >.<

habe die querrys so von Phill bekommen aus seiner shop_item raus geschnitten

und an Mr.Englisch

habs übersetzt , konnte damit aber auch nix anfangen -.-


habe die letzte spalte gelöscht

also des hier:

''

un nun kommt das

[SQL]
INSERT INTO `shop_item` VALUES ('950', '14', '75012', '1',);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

[yym3]

Probier mal ob es so geht :

PHP Code:

INSERT INTO `shop_item` (spaltenname1, spaltenname2, spaltenname3, spaltenname4, spaltenname5) VALUES ('949', '14', '75011', '1', ''); 


(Spaltenname nach db anpassen hab grad keine db vorhanden deswegn...)

[[-Lee-]]

Originally Posted by xchojix

Probier mal ob es so geht :

PHP Code:

INSERT INTO `shop_item` (spaltenname1, spaltenname2, spaltenname3, spaltenname4, spaltenname5) VALUES ('949', '14', '75011', '1', ''); 


(Spaltenname nach db anpassen hab grad keine db vorhanden deswegn...)

nope geht auch nicht

[yym3]

Originally Posted by [-Lee-]

nope geht auch nicht

Hab eben nochmal thread durchgelesen und das bemerkt:

Originally Posted by [-Lee-]

[SQL]
INSERT INTO `shop_item` VALUES ('950', '14', '75012', '1',);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Hast du es so eingegeben wie ich und bei values sowie in diesem zitat? Wenn ja dann ist das "," fehl am platz.

Und das muss eig sowie ich es geshcrieben habe gehen, denn des muss ja wissen in welche spalten es was eingibt!

Womit machst du das eigentlich?

[[-Lee-]]

querry table damit mach ich das , und blödi bin ich ja nicht =(

[yym3]

Hey hab mal eben alten Hamachi server hochgefahren und mit Navicat Console selbst eingegeben, hatte nicht geklappt aber der Code hier klappt:

PHP Code:

INSERT INTO `shop_item` (shop_vnum, item_vnum, count) VALUES ('14', '75012', '1'); 


das "del" kennst du eigentlich weglassen macht er auch allein dann musst du nur noch shop_vnum, item_vnum und die count machen mehr nicht

Hoffe konnte helfen.

[Daunenjacke]

Lee bei deiner query war hinten nochn "," machs weg dann gehts