Query MYSQL prestashop tables

0

Good morning,

My question is that in our web in prestashop there are two rows newsletter and optin that selects the clients.

I would like to change by database the clients that have selected optin you can go to newsletter

The table is ps_custommer The newsletter and optin rows The values are 0 and 1;

Thanks

    
asked by Rafa Alvarez-Ossorio Martin 15.03.2017 в 11:55
source

1 answer

-1
UPDATE ps_customers SET newsletter = 1 WHERE optin = 1.

The default table is customers with an 'M', you have put it with 2. Keep it in mind ...

    
answered by 22.04.2017 в 12:41