how to delete related products from mysql

[AlexeyWinesmoke]

how to delete related products from mysql. more 5000. Как удалить похожие (сопутствующие) товары при помощи sql запроса. Товаров более 5000 тысяч.

[PRO]

backup first


My related products

#_virtuemart_product_customfields
virtuemart_custom_id=1

so if you are wanting the delete all the related proucts, you need to delete those rows that have a virtuemart_custom_id=1

[Milbo]

better is to search for the type R

[Maxim Pishnyak]

CSVI.

[AlexeyWinesmoke]

CSVI.

Что в поле related_products  в csvi написать чтобы они удалились

[Maxim Pishnyak]

Nothing.

[AlexeyWinesmoke]

Nothing.

Так и написать Nothing или поля пустыми оставить?

[Maxim Pishnyak]

Yes, empty.