Здравствуйте, очень прошу вашей помощи.
Это настройки таблицы.
CREATE TABLE IF NOT EXISTS `pictograms_sticked` (
`id_obj` tinyint(4) NOT NULL,
`id_pic` tinyint(4) NOT NULL,
KEY `id_pic` (`id_pic`),
KEY `id_obj` (`id_obj`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Делаю подобный Insert (здесь должен быть длинный запрос):
INSERT INTO `pictograms_sticked`(`id_obj`, `id_pic`) VALUES (103,30),(103,21),(101,8),(103,18),(101,16),(103,16),(101,19),(101,21),(103,15),(101,4),(101,5),(101,15),(103,14),(103,11),(103,5),(102,4),(102,5),(102,15),(102,17),(102,18),(103,4),(102,30),(104,4),(104,5),(104,11),(104,15),(104,16),(104,18),(104,19),(104,21),(104,30),(105,4),(105,5),(105,8),(105,11),(105,13),(105,14),(105,15),(105,16),(105,18),(105,19),(184,30),(106,4),(106,5),(106,8),(106,11),(106,15),(106,16),(106,18),(106,30),(107,4),(107,5),(107,8),(107,13),(107,14),(107,15),(107,16),(107,18),(107,30),(108,1),(111,46),(119,38),(108,4),(108,5),(108,8),(108,13),(108,14),(108,15),(108,16),(108,17),(108,18),(108,19),(108,20),(108,21),(108,30),(109,4),(109,5),(109,8),(109,13),(109,14),(109,15),(109,18),(109,27),(184,11),(110,4),(110,5),(110,15),(110,16),(110,17),(110,18),(110,30),(111,4),(111,41),(111,15),(111,18),(111,30),(112,4),(112,5),(112,11),(112,15),(112,16),(112,18),(112,30),(113,4),(113,5),(113,8),(113,11),(113,14),(113,15),(113,16),(113,17),(113,18),(113,19),(184,42),(111,51),(114,4),(114,5),(114,8),(114,15),(114,16),(114,18),(114,30),(115,4),(115,5),(115,8),(115,15),(115,18),(115,14),(115,16),(115,11),(115,19),(115,21),(115,20),(115,26),(115,27),(116,4),(116,5),(116,14),(116,15),(116,16),(116,18),(116,20),(141,4),(111,21),(117,5),(117,7),(117,8),(117,13),(117,14),(117,15),(117,16),(117,17),(117,18),(117,21),(117,30),(184,17),(118,4),(118,5),(118,8),(118,14),(118,15),(118,16),(118,17),(118,18),(118,20),(118,30),(119,4),(119,5),(119,8),(119,14),(119,15),(119,16),(119,17),(119,18),(119,30),(120,4),(120,5),(120,8),(120,14),(120,15),(120,17),(120,18),(120,30),(121,4),(121,5),(121,8),(121,11),(121,14),(121,15),(121,16),(121,17),(121,18),(121,19),(121,21),(121,25),(121,27),(121,30),(111,50),(114,39),(122,4),(122,5),(122,8),(122,14),(122,15),(122,16),(122,18),(122,21),(122,30),(123,1),(123,4),(123,5),(123,8),(123,14),(123,15),(123,16),(123,17),(123,18),(123,25),(123,27),(123,30),(184,15),(124,4),(124,5),(124,11),(124,14),(124,15),(124,18),(184,38),(125,4),(125,5),(125,15),(125,16),(125,18),(125,20),(126,1),(126,4),(126,5),(126,11),(126,15),(126,16),(126,18),(126,30),(128,4),(128,5),(128,8),(127,11),(128,14),(128,15),(128,16),(128,18),(127,19),(127,21),(128,30),(128,1),(119,45),(127,4),(127,5),(127,8),(127,14),(127,15),(127,16),(127,18),(128,22),(128,27),(127,30),(129,1),(129,4),(129,5),(129,8),(129,14),(129,15),(129,16),(129,18),(129,22),(129,25),(129,30),(184,18),(130,1),(121,40),(130,4),(130,5),(130,8),(130,16),(130,21),(130,22),(131,4),(131,5),(131,11),(131,15),(131,16),(131,18),(131,30),(132,4),(132,5),(132,14),(132,15),(132,16),(132,17),(132,18),(132,19),(132,30),(133,4),(133,5),(133,14),(133,15),(133,16),(133,18),(133,19),(133,30),(134,4),(134,5),(134,14),(134,15),(134,16),(134,18),(134,19),(134,30),(135,4),(135,5),(135,8),(135,15),(135,16),(135,18),(135,30),(136,4),(136,5),(136,11),(136,15),(136,16),(136,17),(136,18),(136,27),(136,30),(137,4),(137,5),(137,8),(137,14),(137,15),(137,18),(137,30),(138,4),(138,5),(138,8),(138,13),(138,14),(138,15),(138,17),(138,18),(138,20),(138,30),(139,4),(139,5),(139,9),(139,14),(139,15),(139,16),(139,17),(139,18),(139,30),(140,4),(140,5),(140,8),(140,14),(140,15),(140,18),(140,19),(140,20),(141,5),(141,8),(141,15),(141,16),(141,17),(141,18),(141,20),(142,4),(142,5),(142,8),(142,9),(142,11),(142,14),(142,15),(142,17),(142,18),(142,19),(142,30),(143,4),(143,5),(143,8),(143,11),(143,13),(143,14),(143,15),(143,17),(143,18),(143,19),(143,30),(184,14),(144,4),(144,5),(144,8),(144,15),(144,16),(144,18),(144,30),(145,4),(145,5),(145,8),(145,15),(145,18),(145,21),(145,30),(146,4),(146,5),(146,8),(146,15),(146,18),(127,27),(147,4),(147,5),(147,11),(147,14),(147,15),(147,16),(147,18),(147,30),(148,4),(148,5),(148,8),(148,13),(148,14),(148,15),(148,16),(148,18),(148,30),(149,4),(149,5),(149,15),(149,16),(149,17),(149,18),(149,19),(149,30),(150,4),(150,5),(150,8),(150,11),(150,14),(150,15),(150,16),(150,17),(150,18),(150,19),(150,26),(150,30),(151,4),(151,5),(151,15),(151,16),(151,18),(151,30),(152,4),(152,5),(152,8),(152,15),(152,18),(152,19),(152,30),(153,4),(153,5),(153,14),(153,15),(153,16),(153,17),(153,18),(153,30),(154,4),(154,5),(154,8),(154,11),(154,15),(154,16),(154,17),(154,18),(154,21),(154,30),(155,4),(155,5),(155,7),(155,8),(155,11),(155,12),(155,13),(155,14),(155,15),(155,16),(155,17),(155,18),(155,19),(155,22),(127,39),(155,26),(155,27),(155,30),(184,45),(155,32),(156,4),(156,5),(156,11),(156,15),(156,16),(156,18),(156,19),(156,21),(156,27),(156,30),(157,4),(157,5),(157,11),(157,15),(157,16),(157,18),(157,19),(157,21),(157,27),(157,30),(158,4),(158,5),(158,13),(158,14),(158,15),(158,16),(158,17),(158,18),(158,21),(158,22),(158,30),(159,4),(159,5),(159,8),(159,13),(159,14),(159,15),(159,16),(159,18),(159,19),(159,21),(159,30),(184,5),(160,4),(160,5),(160,15),(160,16),(160,18),(160,19),(160,30),(161,4),(161,5),(161,8),(161,14),(161,15),(161,16),(161,18),(161,20),(161,22),(161,27),(162,4),(162,5),(162,11),(162,15),(162,16),(162,17),(162,18),(162,30),(163,4),(163,5),(163,14),(163,15),(163,18),(163,25),(163,30),(164,4),(164,5),(164,8),(164,13),(164,14),(164,15),(164,16),(164,18),(164,21),(164,26),(165,4),(165,5),(165,8),(165,13),(165,15),(165,18),(165,22),(165,27),(165,30),(166,4),(166,5),(166,8),(166,11),(166,15),(166,16),(166,17),(166,18),(166,30),(167,4),(167,5),(167,15),(167,16),(167,18),(167,30),(168,4),(168,5),(168,15),(168,16),(168,18),(168,19),(168,30),(169,4),(169,5),(169,11),(169,15),(169,16),(169,18),(170,4),(170,5),(170,21),(170,16),(170,15),(170,18),(170,30),(175,36),(175,30),(175,16),(175,17),(175,18),(175,15),(175,4),(175,5),(174,36),(174,18),(174,15),(174,13),(174,14),(176,4),(176,5),(175,22),(174,8),(174,4),(173,4),(172,30),(174,5),(173,30),(172,11),(173,18),(172,18),(172,16),(172,15),(173,15),(172,5),(173,14),(173,8),(173,5),(172,4),(171,15),(171,7),(171,30),(171,13),(171,21),(171,14),(171,8),(171,5),(171,19),(171,4),(171,11),(171,16),(171,18),(176,8),(176,14),(176,15),(176,18),(176,16),(176,11),(176,20),(176,36),(177,5),(177,4),(177,8),(177,14),(177,15),(177,18),(177,17),(177,16),(177,11),(177,21),(177,30),(177,25),(178,5),(178,4),(178,8),(178,14),(178,15),(178,18),(178,17),(178,16),(178,11),(178,30),(179,5),(179,4),(179,14),(179,15),(179,18),(179,16),(179,19),(179,30),(180,5),(180,4),(180,8),(180,14),(184,4),(180,15),(180,18),(180,16),(180,21),(180,30),(180,36),(181,5),(181,4),(181,8),(181,14),(181,15),(181,18),(181,16),(181,11),(181,30),(181,36),(111,14),(111,8),(111,45),(158,48),(182,5),(182,4),(182,14),(182,15),(182,18),(182,17),(182,16),(182,30),(182,36),(183,5),(183,4),(183,8),(183,15),(183,18),(183,16),(183,21),(183,30),(183,36),(183,32),(111,5)
Здесь 763 строки. Из них строк со значением 127, поля `id_obj` -- 12 штук.
После того как делаю Isert, в базу попадает 522 строки со значением 127, поля `id_obj`
Все остальное, что осталось. Кто-нибудь может подсказать в чем может быть магия?