Can we remove carriers from all products at once?

[lepusa]

The post I linked to below solves the well known issue of "There are no carriers that deliver to the address you selected":

https://www.prestashop.com/forums/topic/261489-there-are-no-carriers-that-deliver-to-the-address-you-selected/page-2

The issue comes about when there are specific carriers applied to products (Catalog -> Products, edit an item, then click on Shipping on the left). Leaving the carriers field blank allows a product to be shipped by any carrier, which is what we want:

 

So, we would like to remove all carriers from all products without having to do it one product at a time via the admin GUI. I assume that an SQL query will be needed, but that's not really my strong suit… ;-)

Any help would be greatly appreciated!

Edited January 19, 2017 by lepusa (see edit history)

[NemoPS]

All products? Try via sql, DELETE FROM ps_product_carrier