> You can use REPLACE instead of making two separate queries (UPDATE and
> INSERT) because it checks if it is there, and if it's not, then it
adds
> it;
> otherwise it updates it. I think that's right ... but the SQL
server's
> SQL
> server is broken! (the irony!)
Just note that REPLACE is MySQL
You can use REPLACE instead of making two separate queries (UPDATE and
INSERT) because it checks if it is there, and if it's not, then it adds it;
otherwise it updates it. I think that's right ... but the SQL server's SQL
server is broken! (the irony!)
That won't solve all of your problems, but
2 matches
Mail list logo