Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => PostgreSQL and SQLite Support => Topic started by: brunob on October 14, 2013, 04:58:31 PM

Title: Pm email notify encourage all members.
Post by: brunob on October 14, 2013, 04:58:31 PM
Hello,

I'm using the following.

I want all the zeros in Table pm_email_notify zero on a set.

How can I do this all at once? Involves more than 1,000 members to do so manually each is almost impossible to do.

Can do this through phpadmin? and then build through query?

Regards Bruno
Title: Re: Pm email notify encourage all members.
Post by: margarett on October 14, 2013, 05:03:28 PM
That's a nice name you have :P

I've never ever see this kind of DB type but you should look into something like
UPDATE table_name
SET column_name = 0

This would work in MySQL...
Title: Re: Pm email notify encourage all members.
Post by: Herman's Mixen on October 14, 2013, 05:57:52 PM
Bruno please do not cross post between boards you already have your answer in the Dutch boards ;)
Title: Re: Pm email notify encourage all members.
Post by: brunob on October 14, 2013, 06:19:04 PM
Hello The Bulgar,

there are people the don't  can't read Dutch  ;) And they also don't speak Dutch  ;D

I will ensure you that I do not do that again about cross posting.

Greetings (groetjes) Bruno  ;D