how come this
query:
select * FROM
`store_catalog_product_option` JOIN `store_catalog_product_option_type_value` WHERE
`product_id`=15676 AND `store_catalog_product_option_type_value`.`sku` LIKE '%UNIT_%'
retrieve
datas
but replacing
select *
with
delete
as such
delete FROM
`store_catalog_product_option` JOIN `store_catalog_product_option_type_value` WHERE
`product_id`=15676 AND `store_catalog_product_option_type_value`.`sku` LIKE
'%UNIT_%'
give syntax
error:
SQLSTATE[42000]: Syntax error or access violation: 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 'JOIN
store_catalog_product_option_type_value
WHERE
product_id
=15676 AND `sto' at line
1
No comments:
Post a Comment