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

Path	csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From	Thomas 'PointedEars' Lahn <PointedEars@web.de>
Newsgroups	comp.lang.php
Subject	Re: sql how capture on the fly the row's id when is updated
Date	Sat, 01 Aug 2015 20:33:46 +0200
Organization	PointedEars Software (PES)
Lines	21
Message-ID	<1751830.Gj4ZAJ2E97@PointedEars.de> (permalink)
References	<mpi2nt$gpp$1@speranza.aioe.org>
Reply-To	Thomas 'PointedEars' Lahn <php@PointedEars.de>
Mime-Version	1.0
Content-Type	text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding	7Bit
X-Trace	solani.org 1438454223 10028 eJwFwQkBwDAIA0BLlCcsclgB/xJ6F4aDm46Ax8ZyJz9wIMwKWbECVX+fdnL0JlOPikl0mfQDDOUQTg== (1 Aug 2015 18:37:03 GMT)
X-Complaints-To	abuse@news.solani.org
NNTP-Posting-Date	Sat, 1 Aug 2015 18:37:03 +0000 (UTC)
User-Agent	KNode/4.14.2
X-User-ID	eJwVwoENACEIA8CVQErRcRBw/xE+nzs3KitAJ/z9cq+zrJ1ifQvLj+yRUaAllM9vab39WgczZqkxVB8mkPEBRUAVWw==
Cancel-Lock	sha1:T7P1OHlIgtTRvJ+Ur5hItOIyvCc=
X-NNTP-Posting-Host	eJwNycEBwCAIA8CZRIJxHMCw/wjtfQ87VvTxQDgGs1OwSfDtNJGWtyrvqcegVDLNcjj7L/P+ADGVEco=
Xref	csiph.com comp.lang.php:15620

Show key headers only | View raw

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?

Yes.
 
-- 
PointedEars
Zend Certified PHP Engineer
Twitter: @PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.

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