Subject Re: [firebird-support] update all records
Author
Post date 2016-05-05T20:50:57Z
Hi,
 
1=1 => true
 
“where true” is always true
this is oposite to 1=0 => false
 
and this statements are equal:
update stock set actualizar = 0 where 1=1;
update stock set actualizar = 0;
 
regards,
Karol Bieniaszewski

 
 
Sent: Thursday, May 5, 2016 9:55 PM
Subject: Re: [firebird-support] update all records
 
 

Hello,

I don't understand your SQL :
"Where 1=1"   first "1" is a field name ?

if "Where actualizar=1" it may works ?
The condition is on records, and must use fields values...no ?

If you don't use condition, all records should be updated to the same value 0...

"Update stock set actualizar=0"  should update all records with actualizar =0 to whole stock table...

With best regards,
Mikey


Le Jeudi 5 mai 2016 19h19, "kristinwensley@... [firebird-support]" <firebird-support@yahoogroups.com> a écrit :


 
Thanks


On Wednesday, May 4, 2016 6:45 PM, "shg_sistemas@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:


 
hello! I've been googling but found nothing about it.

Why this sentence does not update all the records in the table? (FB 2.5)

update stock set actualizar = 0 where 1=1

Thanks!!

Sergio