Таблица Код | CREATE TABLE `table` ( `value_id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID', `entity_type_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Entity Type ID', `attribute_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Attribute ID', `store_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Store ID', `entity_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Entity ID', `value` INT(11) NULL DEFAULT NULL COMMENT 'Value', PRIMARY KEY (`value_id`), UNIQUE INDEX `UNQ_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`, `attribute_id`, `store_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_INT_STORE_ID` (`store_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID` (`entity_id`), CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_INT_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON UPDATE CASCADE ON DELETE CASCADE ) COMMENT='Catalog Product Integer Attribute Backend Table' COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=11108022;
|
Требуется обновить значение value, есть уже есть запись Код | INSERT INTO catalog_product_entity_int (value_id, entity_type_id, attribute_id, store_id, entity_id, value) VALUES (873657,1,2,3,693755, 1) ON DUPLICATE KEY UPDATE не могу понять что тут требуется
|
Добавлено через 11 минут и 24 секундыПРоблема решена Код | INSERT INTO table (value_id, entity_type_id, attribute_id, store_id, entity_id, value) VALUES (8736571,1,2,0,693755,1) ON DUPLICATE KEY UPDATE value = VALUES(value)
|
--------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~WoW CafeSayber © Портфолио ~~~~~~~~~~~~~~~~~~~~~~~~~~~
|