At 21:05 -0600 3/7/02, John Hunter wrote: >I just did > >delete from some_table where 1>0; > >when I wanted to do > >delete from some_table where pid=1234; > >Oops! > >Nothing else has been done to the database since then. Can I undo or >not commit these changes?
You can undo them using your backup. Otherwise, no. > >I am sure this is a FAQ, but I am in a panic so I would be much >obliged if someone can offer some quick help or tell me to go to a >backup (too old :-( ) or go drown my sorrows in a beer. > >Thanks, >John Hunter > >mysql version 3.23.37 >sql,select (keywords to match spam filter) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php