|
|
|
|
|
|
by carterehsmith
3305 days ago
|
|
|
> I'd love a database or SQL spec extension that provided a 'dry-run' mode for UPDATE or DELETE and which would report how many rows would be impacted. I mean, if your DB supports transactions, you are in luck. Start a transaction (that may be different among vendors - BEGIN TRANSACTION or SET AUTOCOMMIT=0 etc) and run your stuff. If everything looks good, commit. If you get OOOps number of records, just rollback. |
|
|