[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: auto insert to another table
From:       Baron Schwartz <baron () xaprb ! com>
Date:       2009-02-27 13:43:08
Message-ID: 4cfa0b030902270543vb254528o8f2f6d6b8f302120 () mail ! gmail ! com
[Download RAW message or body]

You can probably use a trigger.  Check the section of the manual that
explains triggers.

Baron

On Fri, Feb 27, 2009 at 8:04 AM, Ron <ron@silverbackasp.com> wrote:
> Hi All,
>
> is it possible to auto insert to another table once a new data is inserted
> on a table? i'm using asterisk mysql cdr, what i'd like to do is once
> asterisk insert  new data on the cdr table, i will insert to another table
> which includes already how much the call was coz i dont want to queyr the
> cdr table all the time and compute how much.
>
> thank you
>
> regards,
> ron
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=baron@xaprb.com
>
>



-- 
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]