synchronized write

[ankursaxena]

Hi! i have a program which writes to the database, now if i run 2 copies of the same thing, would the writting be atomic. i mean it will lock the database before it write so that someone else cant write/read? so i dont need to worry about snychronizing it myself rite?
help would be greatly appreciated.
thanx a lot in advance

 

[petersJazz]

If it just one operation its safe.

But if you need to do two or more operations you can use the sql statement lock table.

In other database systemes you would set autocommit false and do commit/rollback.