how to delete related products from mysql

AlexeyWinesmoke · November 11, 2013, 00:40:47 AM

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

PRO · November 11, 2013, 02:57:42 AM

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 · November 11, 2013, 11:47:46 AM

better is to search for the type R

Maxim Pishnyak · November 11, 2013, 21:39:29 PM

CSVI.

AlexeyWinesmoke · November 11, 2013, 23:50:01 PM

Quote from: Maxim Pishnyak on November 11, 2013, 21:39:29 PM
CSVI.

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

Maxim Pishnyak · November 11, 2013, 23:55:05 PM

Nothing.

AlexeyWinesmoke · November 12, 2013, 00:07:23 AM

Quote from: Maxim Pishnyak on November 11, 2013, 23:55:05 PM
Nothing.

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

Maxim Pishnyak · November 12, 2013, 18:09:08 PM

Yes, empty.

News:

how to delete related products from mysql