3 ms·
I'm actually doing something else when updating a webshop from a remote source.. I convert all objects that i import to a big SQL Query. Something like First
by NicoJuicy 10y ago
I'm actually doing something else when updating a webshop from a remote source..
I convert all objects that i import to a big SQL Query.
Something like
First query: UPDATE table SET active=0;
Second ( big ) query:
UPDATE table SET properties=values
IF ROWCOUNT =0
INSER INTO table(properties)VALUES(values)