On 7 November 2010 16:20, Andre Lopes <lopes80an...@gmail.com> wrote:
> Sorry for not explain well. > > I mean update more than one table at the same time with something like > this: > > update table1, table2 > set > table1.f1 = 'aaa', > table2.date = '2001-01-01' > where > table1.id = 'x1' and table2.id = 'x1' > > Something like this is possible? It is the best way to do it? > > Best Regards, > > This is not possible, however you could do two updates in one transaction. regards Szymon
