Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #15619

Re: sql how capture on the fly the row's id when is updated

Show all headers | View raw

On Sat, 01 Aug 2015 11:15:52 +0200, alex wrote:
> UPDATE  a AS a
>   INNER JOIN c AS c  ON  a.id = c.id
>   SET     a.total = 1
>   WHERE b.x < c.y
>
> this sql, in the table a total's field, insert the value 1 under certain 
> conditions; in some rows the value already exists and will only insert 
> in other lines;
> is possible put in an array php only the id of the rows updated?
>
> es nel caso sotto su 1  6 ho già il valore; con sql vado a d inserire
> solo nella riga 3
>
> example
> table a
> id     total
> 1       1 already there is
> 2	0
> 3	0 only here the sql will insert the new value
> 4	0
> 5	0
> 6	1 already there is
> 7	0
> ...
> 1000	0
>
> I think is necessary, while sql loop the rows, when a row is updated,
> capture the id and insert in the php array, but how?

Forget about SQL looping the rows; it might be doing that but you cannot
know that it is because it might also NOT be doing that. It's entirely
up to the SQL engine how to do something.

The correct way to do this is to do it using ONLY SQL, in several
queries, enveloped in a single transaction/unit of work. That should be
enough information to get you started on your own research, or re-ask
your question in a database newsgroup that's appropriate.

-- 
Windows gives you a nice view of clouds so you can't see any potentially
useful boot time messages.
              -- Bill Hay in the Monastery

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-01 11:15 +0200
  Re: sql how capture on the fly the row's id when is updated Denis McMahon <denismfmcmahon@gmail.com> - 2015-08-01 14:51 +0000
  Re: sql how capture on the fly the row's id when is updated "Peter H. Coffin" <hellsop@ninehells.com> - 2015-08-01 10:03 -0500
  Re: sql how capture on the fly the row's id when is updated Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-01 20:33 +0200
  Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-01 15:44 -0400
    Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-01 22:01 +0200
      Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-01 16:13 -0400
        Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-02 01:51 +0200
          Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-01 21:38 -0400
    Re: sql how capture on the fly the row's id when is updated Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-02 14:42 +0200
      Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-04 19:24 +0200
        Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-04 14:55 -0400
          Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-05 01:13 +0200
        Re: sql how capture on the fly the row's id when is updated Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-04 21:29 +0200
          Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-05 01:01 +0200
            Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-05 01:03 +0200
            Address munging considered harmful (was: sql how capture on the fly the row's id when is updated) Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-05 10:08 +0200

csiph-web