| Post AyCesULBrDVn4H6pGq 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 #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 #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 #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, 1 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 #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 #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… |