|Subject||Re: [firebird-support] update all records|
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;
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,
Le Jeudi 5 mai 2016 19h19, "kristinwensley@... [firebird-support]" <firstname.lastname@example.org> a écrit :
On Wednesday, May 4, 2016 6:45 PM, "shg_sistemas@... [firebird-support]" <email@example.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