List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:July 20 2005 11:24am
Subject:Re: Conditional insert or update.
View as plain text  
Hello.


Please, provide more information on your's application logic.
To catch events which occurs for the table use triggers. See:
  http://dev.mysql.com/doc/mysql/en/triggers.html

Unfortunately they're available only in MySQL 5.0.x, which is still
beta.


Paul Halliday <paul.halliday@stripped> wrote:
> Hi,=20
> 
> I have a table that looks something like this:
> 
> ip | mac_current | mac_change
> 
> now if I have an entry that looks like this
> 
> 10.0.0.1 | 11:11:11:11:11:11:11 | NULL
> 
> If the next time the script runs and the mac has changed, how can I
> catch this and put the new MAC into mac_change?
> 
> Ultimately, I would also like to roll the values too. For example if
> the MAC changes again, put mac_change into mac_current...
> 
> 
> Thanks.
> --=20
> 
> Paul Halliday
> 
> "Diplomacy is the art of saying "Nice doggie!" till you can find a rock."
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Conditional insert or update.Paul Halliday20 Jul
  • Re: Conditional insert or update.Gleb Paharenko20 Jul
    • Re: Conditional insert or update.Paul Halliday20 Jul