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 -- http://mail.python.org/mailman/listinfo/python-list
