On 11 Aug., 21:23, "Rami Chowdhury" <rami.chowdh...@gmail.com> wrote: > IIRC Postgres has had ON DUPLICATE KEY UPDATE functionality longer than > MySQL... >
Ok, I've completely failed here :) Thanks, man > > > > > On Tue, 11 Aug 2009 11:45:50 -0700, Pet <petshm...@googlemail.com> wrote: > > On 11 Aug., 20:39, Kushal Kumaran <kushal.kumaran+pyt...@gmail.com> > > wrote: > >> On Tue, Aug 11, 2009 at 10:03 PM, someone<petshm...@googlemail.com> > >> wrote: > >> > Hello, > > >> > I'd like to make insert into db if record not exist otherwise update. > >> > to save typing list of columns in both statements I do following > > >> > <snip> > > >> > is there better or more readable way to do it? > > >> Well, mysql, in particular, offers an "on duplicate key update" clause > >> that you can take a look at. Don't know about about other databases. > > >> -- > >> kushal > > > Oh, forgotten to mention. It's PostGres > > -- > Rami Chowdhury > "Never attribute to malice that which can be attributed to stupidity" -- > Hanlon's Razor > 408-597-7068 (US) / 07875-841-046 (UK) / 0189-245544 (BD) -- http://mail.python.org/mailman/listinfo/python-list
