Thank you for the reply.
However, this solution (though I'm ready to use it) would create a lot
of SQL queries comparing it with simple INSERT ... ON DUPLICATE KEY
UPDATE.
On the other hand, I admit the INSERT ... IN DUPLICATE KEY UPDATE
might not be available in other DBs. I would like the
camlost wrote:
Thank you for the reply.
However, this solution (though I'm ready to use it) would create a lot
of SQL queries comparing it with simple INSERT ... ON DUPLICATE KEY
UPDATE.
On the other hand, I admit the INSERT ... IN DUPLICATE KEY UPDATE
might not be available in other DBs.
camlost wrote:
hello,
i'm trying to use sqlalchemy 0.5.1 with python 2.5.4 on windows. and
mysql 5.1.
the task is simple: to keep fresh information about our servers.
i can get a list of server names from AD, get some info about them and
insert them into DB using Session.add().
if i run