The only way I can guarantee a transaction is in a Function or there are other ways?
Best Regards, On Sun, Nov 7, 2010 at 3:22 PM, Szymon Guz <mabew...@gmail.com> wrote: > > > 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 >
