Currently we have some options to SQL
(INSERTs
, REPLACEs
and DELETEs/INSERTs
).
I think that we should have a new option like UPDATEs
, that will create a SQL
to UPDATE
existing data, based on PK
.
Example:
id | keys
1 | ABC
2 | DEF
UPDATE table SET `keys ` = "ABC" WHERE `id` = 1;
UPDATE table SET `keys ` = "DEF" WHERE `id` = 2;
Note: the SET
don't need include the PK.