Re: Insert...on duplicate with aggregate

2008-02-27 Thread Phil
Awesome! Thanks Baron, works perfectly.. Phil On Tue, Feb 26, 2008 at 10:06 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > Hi! > > On Tue, Feb 26, 2008 at 7:04 PM, Phil <[EMAIL PROTECTED]> wrote: > > I have a table countrystats defined as > > > > CREATE TABLE IF NOT EXISTS `countrystats` ( >

Re: Insert...on duplicate with aggregate

2008-02-26 Thread Baron Schwartz
Hi! On Tue, Feb 26, 2008 at 7:04 PM, Phil <[EMAIL PROTECTED]> wrote: > I have a table countrystats defined as > > CREATE TABLE IF NOT EXISTS `countrystats` ( > `proj` char(6) NOT NULL default '', > `country` char(50) NOT NULL default '', > `score` double default NULL, > `nusers` int(11) d

Insert...on duplicate with aggregate

2008-02-26 Thread Phil
I have a table countrystats defined as CREATE TABLE IF NOT EXISTS `countrystats` ( `proj` char(6) NOT NULL default '', `country` char(50) NOT NULL default '', `score` double default NULL, `nusers` int(11) default NULL, `RAC` double default NULL, `last_update` double default NULL, PRI