Re: guideline for creating temporary (working) table

"DJ" <nospamplease_at_goaway.com> writes:

>>>Reason for not having truncate in production is because you might
>>>truncate the wrong table.

>>If you have delete permission on a table, then it is equally easy to
>>'delete from wrong_table'.

>but with delete from <table> I can then do
>
>ROLLBACK :-)
Good point, I wasn't thinking of the developer who bothers to check his changes before committing them :-).

-- 
Ed Avis <ed_at_membled.com>