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 <r...@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=ba...@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=arch...@jab.org