News for hackers. Stuff that matters.
Re:Heroku Fucking Console by enjo on Friday March 01, 2013 @11:52AM (#5305342)
The old "DELETE FROM some_table" <enter>

Crap.. I meant "DELETE FROM some_table WHERE id=1"

sighs

Re:Heroku Fucking Console by vidarh on Friday March 01, 2013 @01:55PM (#5306160)
The MySQL command line client has an argument "--i-am-a-dummy" that refuses to run UPDATE and DELETE's without a WHERE clause.

More commands could use options to adjust how big guns they let you fire at your feet with...

Re:Heroku Fucking Console by gknoy on Friday March 01, 2013 @04:58PM (#5307199)
Such options might be more appealing to users if it were named something like "--extra-safety" or "--require-where".
Re:Heroku Fucking Console by NSAID on Friday March 01, 2013 @05:36PM (#5307408)
Re:Heroku Fucking Console by sneak on Friday March 01, 2013 @05:00PM (#5307215)
...which is not the default. Fuck them.
Re:Heroku Fucking Console by iaskwhy on Friday March 01, 2013 @12:26PM (#5305590)
I always SELECT first and confirm I got the right result. Then I add the DELETE just before SELECT and commment out the SELECT line. Never fails!
Re:Heroku Fucking Console by naudo on Friday March 01, 2013 @12:11PM (#5305470)
After doing that on a local db a couple of times, I started just writing the where clause first. Goes like this

WHERE id = 1 ctrl + a DELETE FROM....

Found it's also helpful for writing SELECTS and avoiding the whole "oh crap, now let's load the entire DB" type of moments.

Re:Heroku Fucking Console by schrodinger on Friday March 01, 2013 @01:33PM (#5306017)
If you're in a GUI where you can run only the highlighted code, I do this:

    select * -- delete
    from sometable
    where id = 1
Then you can run the whole thing to see what would be deleted, and highlight starting at the word delete to actually delete.
Re:Heroku Fucking Console by methurston on Friday March 01, 2013 @02:57PM (#5306587)
I do this too, If I'm saving the file for reuse, I wrap the entire thing in /* */ when I'm done just in case I accidentally hit run script instead of run statement.
Re:Heroku Fucking Console by TrunkleBob on Friday March 01, 2013 @03:31PM (#5306772)
Do that once on a production system in the middle of a shipping run. Lesson learned.

All my deletes written first as selects now, as a sibling comment suggested.

Re:Heroku Fucking Console by ams6110 on Saturday March 02, 2013 @10:21PM (#5312349)
That's what transactions are for. you realize the mistake, type ROLLBACK, and move on.

Oh yeah, you're using a toy database aren't you.