比较文本

查找两个文本文件之间的差异

实时编辑器
折叠未更改行
关闭换行
视图
比对精度
语法高亮

update low_stock_date

创建于 差异永不过期
7 删除
16 行
9 添加
15 行
UPDATE `cataloginventory_stock_item`
UPDATE `cataloginventory_stock_item`
SET `low_stock_date` = IF((use_config_notify_stock_qty = 1
SET `low_stock_date` = IF((use_config_notify_stock_qty = 1
AND qty < 3)
AND qty < 3)
OR (use_config_notify_stock_qty = 0
OR (use_config_notify_stock_qty = 0
AND qty < notify_stock_qty), '2020-11-18 22:02:11', NULL)
AND qty < notify_stock_qty), '2020-11-18 22:25:38', NULL)
WHERE (website_id = 0
WHERE (website_id = 1)
AND ((use_config_manage_stock = 1
AND (product_id IN
AND 1 = 1)
OR (use_config_manage_stock = 0
AND manage_stock = 1))
AND product_id IN
(SELECT `catalog_product_entity`.`entity_id`
(SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
FROM `catalog_product_entity`
WHERE (type_id IN('simple',
WHERE (type_id IN ('simple',
'virtual',
'virtual',
'downloadable'))))
'downloadable'))))
AND ((use_config_manage_stock = 0
AND manage_stock = 1)
OR use_config_manage_stock = 1)
已保存差异