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

Groups > comp.lang.php > #15634

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

Path csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From alex <alex@nomailno.it>
Newsgroups comp.lang.php
Subject Re: sql how capture on the fly the row's id when is updated
Date Wed, 05 Aug 2015 01:13:07 +0200
Organization Aioe.org NNTP Server
Lines 24
Message-ID <mprgu1$a4e$1@speranza.aioe.org> (permalink)
References <mpi2nt$gpp$1@speranza.aioe.org> <87a8uaokt1.fsf@ahungry.com> <2899955.DplpsR2aGK@PointedEars.de> <mpqsgo$no2$1@speranza.aioe.org> <871tfi993v.fsf@ahungry.com>
NNTP-Posting-Host I5N2pmPNJ7+Pk7zYBTpNcg.user.speranza.aioe.org
Mime-Version 1.0
Content-Type text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding 7bit
X-Complaints-To abuse@aioe.org
User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0
X-Notice Filtered by postfilter v. 0.8.2
Xref csiph.com comp.lang.php:15634

Show key headers only | View raw

> It is probably the easiest for a new PHP programmer to understand (

ok

> For a real world use case, go with what Thomas posted (keep track of
> last updates via database).

A
> If you're using MySQL (and probably most other database engines these
> days) you can put this logic in the query itself using the ON UPDATE clause.


B
> If your database does not support that, you can just add a new datetime
> or timestamp column type and insert or update that value whenever the
> column is modified (then to get the changed rows, query based on that
> time).
>


not understand the case A
I have mysql 5.1.x, can do an example ?

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