 |
Post AyCK5RRXqLw2oCPtrM by [email protected] |
 |
More posts by [email protected] |
|
Post #AyCGmOTQMQb2EYWOHY by [email protected] |
|
0 likes, 2 repeats |
|
|
|
The great thing about Unix CLI or SQL syntax is that if you know what you'r… |
|
|
|
Post #AyCGwr1X4CuTfzSmPY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixcraft a pragma of sorts at least. |
|
|
|
Post #AyCH0VVT0d8k6HCsRk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft DBeaver is a multi-db GUI which warns you about that.(Also has a few … |
|
|
|
Post #AyCH8p1sJA4ExvKWxc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft @lizardbill you mean like WHERE 1 = 1? Yes, yes. |
|
|
|
Post #AyCHAiB8kVzwIXZ596 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft "explain" all the delete |
|
|
|
Post #AyCHHZfInheVv9wffE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
With great power comes great responsibility. |
|
|
|
Post #AyCHN7TqVIt4FFENZA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft good idea; if you really want to effect all records, you can say WHER… |
|
|
|
Post #AyCIPFiWwz6SKAgFSi by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@nixCraft You only have to type: sudo rm -rf /. Instead of: sudo rm -rf ./ once… |
|
|
|
Post #AyCIbSxxW8EytEil6m by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft I've actually built up the habit of always writing the "wher… |
|
|
|
Post #AyCIm0eP8LC6FybNQW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft |
|
|
|
Post #AyCImVPalSlVf0uU8u by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft I mean: You still get something done ... just not the something you w… |
|
|
|
Post #AyCJcBSCDGbooulo1o by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft oh yes! I had once to correct a typo in the employee database:`update… |
|
|
|
Post #AyCK5RRXqLw2oCPtrM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft I think I would argue that requiring WHERE TRUE, or the like would ju… |
|
|
|
Post #AyCKH4AoBbxA758DNA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft top search result: "I don't know what that error means, but … |
|
|
|
Post #AyCKMtD5rNHTqhydYO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft `mysql --i-am-a-dummy` |
|
|
|
Post #AyCKVAe6uyhwF3YxO4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft the way it should. I don’t need hand holding and if i screw up, I�… |
|
|
|
Post #AyCKZeyc5iI5T9IFwO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft A few months ago I wanted to wipe two partitions on two of my SSDs. I… |
|
|
|
Post #AyCL5IGq2z3qJXu06S by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft Don’t know anything about a missing WHERE clause but the rest of th… |
|
|
|
Post #AyCLyLdtDERchNw6NM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraftSame as C programming language |
|
|
|
Post #AyCMrCAO92f3ElI44O by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@Zergy @nixCraft Bootloader? Try glibc. |
|
|
|
Post #AyCN608h90lYHLYfse by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@AndreasMathe @nixCraft sudo cancel --previous --add-option "pretty please… |
|
|
|
Post #AyCN79YhbmkxmZGwm8 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] of course i know what i am doing. reading mails reall… |
|
|
|
Post #AyCN7RV6tsZvQdjKfw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@hypostase @nixCraft WHERE TRUE should be fine because that shows intention. A … |
|
|
|
Post #AyCN7RbUW9gNkQiQca by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jens_d @nixCraft A sharp knife needs only understanding. And not being left ly… |
|
|
|
Post #AyCNOBZxLnDSyFyrL6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft reminds me of a couple of (likely well known) quotes i like:"Uni… |
|
|
|
Post #AyCPdrQqDxXt1mJrRQ by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@nixCraft It's so simple to avoid terrible mistakes in interactive #SQL too… |
|
|
|
Post #AyCQgjwobgvKdeDBfk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft you have to dissable auto commit 😅 |
|
|
|
Post #AyCQo7HAGtk716FOL2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Lightfighter @nixCraftDon't get into a habit of using -f, only use it when… |
|
|
|
Post #AyCQo7NXtAqZKtEUHg by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@leeloo @nixCraft When you don't realize that you swapped the / and the . … |
|
|
|
Post #AyCRF0vXz3Xz94xgDg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft Once I worked on an intermediate SQL layer where all UPDATE and DELET… |
|
|
|
Post #AyCRfRu8J1HULJuC48 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft DELETE FROM Students WHERE 1=1; |
|
|
|
Post #AyCRpVZTWlWibx2VV2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Zergy @nixCraft a fair version of this would have the user uninstall edge and … |
|
|
|
Post #AyCRwXi3yVSZGqPWPw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
CRYteria |
|
|
|
Post #AyCThcGwvdEAzCjray by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft @catsalad DELETE FROM Users WHERE 1=1; |
|
|
|
Post #AyCTt7LtiNq0Z1XNnU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Lightfighter @nixCraftIf you are trying to delete the root partition, and you … |
|
|
|
Post #AyCTt7SzI1Vcv0r2qe by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@leeloo @nixCraft It was 15 years ago, who knows, I was making a mistake. |
|
|
|
Post #AyCUEPEmPgSu7CMKxs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft I became known as a tad scary in one of my jobs when I wouldn't w… |
|
|
|
Post #AyCUUnv6Pa0bIfyTzM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Lightfighter @nixCraftAbout the same time frame I was telling my colleagues no… |
|
|
|
Post #AyCUUo2BzDgDefI92W by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@leeloo @nixCraft Delete all directories beneath where I am now. Pretty sure th… |
|
|
|
Post #AyCV8DypSFAhPyVy6q by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft The character trait I associate with the best dB people is patience. … |
|
|
|
Post #AyCV8HSMWtZuCRM63k by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Lightfighter @nixCraft/ is the root of the file system./. is the root.. is the… |
|
|
|
Post #AyCVCECuYHnFHT0iUS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Lightfighter I did rm -rf * .txt once. In ~ 🥳 |
|
|
|
Post #AyCWixHab8AYIhMseu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft in the case of SQL is doesn't just assume you know what you'r… |
|
|
|
Post #AyCWiylP5lc0tSKClk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@tipiak75 the "Sudo Man" |
|
|
|
Post #AyCYkhNUtz8rSc5gDw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft WHERE 1 = 1 |
|
|
|
Post #AyCZhJwveUk7sqcHya by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@chris @nixCraft @catsalad https://tenor.com/yhie.gif |
|
|
|
Post #AyCZhp3O0XKOLqsNqS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jgj @nixCraft what? I don't get it. |
|
|
|
Post #AyCZjOXtXCMqiYtcMi by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jernej__s Many years ago, I wanted to create a 1:1 backup of a firewall system… |
|
|
|
Post #AyCZmYY0nuvAbgSTlA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jernej__s :rp_thisisfine: @nixCraft |
|
|
|
Post #AyCZpf7mo7cVsEflB2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bedast @nixCraft heh, why shouldn't one team be slowed down just to make u… |
|
|
|
Post #AyCdcvWav8D6n2SWtE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft How no? How about resist the urge to add nags to everything? How abou… |
|
|
|
Post #AyCdpYwuARV8XNn66i by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft From `man mariadb` (MySQL had it originally):``` • --safe-u… |
|
|
|
Post #AyCerGfRD2YAN3zvHM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@karthik Say, there is a table with row:id=1, timestamp=ymdhms, key=value,delet… |
|
|
|
Post #AyCesULBrDVn4H6pGq by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@moranaga @nixCraft Mine wasn't headless, this is what the console looked l… |
|
|
|
Post #AyCgJiGAJaVg0fIvTM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft Same goes with any programming language. I accidentally wiped my sour… |
|
|
|
Post #AyCh34qvA6kh6y7zAO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft where 1 = 1 |
|
|
|
Post #AyCiW7PooQEVPbrY92 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft reminds me of the time I had to manually reset a password in our data… |
|
|
|
Post #AyCiuKuCJBOwCUcVO4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft I do have a habit of writing the where clause first, because of I'… |
|
|
|
Post #AyCl3Bpjbh72ZwskVs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft Nice, I’ve had a few long nights recovering from my error. |
|
|
|
Post #AyClUDfksSyo6L6Re4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft don't forget the third kind where you know what you're doing … |
|
|
|
Post #AyClghhH4a5mhBlaTI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jernej__s „Do you always look at it encoded?“„Well, you have to.“@nixC… |
|
|
|
Post #AyCsbiB2Yly6PqFvay by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft "Along with it [Unix] came a set of disgustingly dangerous utili… |
|
|
|
Post #AyD0Ss5j82PGBw4AgC by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft This is why you run *every* PostgreSQL script first with "BEGIN;… |
|
|
|
Post #AyDCzTCFuFvDzKQl72 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft don't worry about it, everyone's doing fully-tested event-sou… |
|
|
|
Post #AyDFb7gaWz5ABbhUnI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@kitten_tech @nixCraft This is why I as a developer refuse to accept a producti… |
|
|
|
Post #AyEDZGPD8Q6RttWB6G by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft @stefano Your boss, if you have one, assumes you know what you are do… |
|
|
|
Post #AyEhQhhFIP90YnmvQ0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nixCraft I dimly remember a quip, years ago, that C (and/or UNIX?) was like na… |
