AK
Size: a a a
AK
IZ
А
IZ
IZ
MC
DELETE FROM attribute as attr
WHERE NOT EXISTS
(
SELECT null
FROM attribute as attr2
WHERE attr.parent_attribute_id = attr2.id
)
AND attr.parent_attribute_id IS NOT NULL
MC
MC
IZ
DELETE FROM attribute as attr
WHERE NOT EXISTS
(
SELECT null
FROM attribute as attr2
WHERE attr.parent_attribute_id = attr2.id
)
AND attr.parent_attribute_id IS NOT NULL
IZ
DELETE FROM attribute as attr
WHERE NOT EXISTS
(
SELECT null
FROM attribute as attr2
WHERE attr.parent_attribute_id = attr2.id
)
AND attr.parent_attribute_id IS NOT NULL
MC
IZ
MC
MC
MC
mysql> DELETE FROM attribute WHERE id IN (SELECT id FROM attribute as attr WHERE NOT EXISTS (
SELECT null FROM attribute as attr2 WHERE attr.parent_attribute_id = attr2.id ) AND attr.parent_attribute_id IS NOT NULL);
ERROR 1093 (HY000): You can't specify target table 'attribute' for update in FROM clause
MC
MC
You can't specify target table 'attribute' for update in FROM clause
MC
MC