Dotan Cohen wrote:
There are enough horror stories about the no-WHERE-clause DELETE
statements. What single keystroke could wipe out a spreadsheet?
hmm - highlight all the rows/columns (kind of like writing that delete
statement)
then.....
hit <del>
(granted that is only a sheet)
or
close your spredsheet - go to your file browser - highlight the file
then....
hit <del>
Does that count?
OK so in the first instance you could use UNDUE to get the data back.
In a relational database there is a concept of a transaction.
Any DBA (worth their salt) would know that when doing mass deletes (or
updates)
the process is:
Start Transaction
Perform your mass change
CHECK YOUR WORK
If it is correct
COMMIT (this makes it permanent)
if not
ROLLBACK (this will UNDUE the chagnes )
For the second example one needs to go to the Backups.
Yes you can backup a database also.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
