These Two Will Be Married In 100 Days - Ch. 74 - Day 74

[GalladeGuy]

@Mogima I'd recommend C just because that's what I learned first and it's pretty good as a general purpose language, but what you should learn really depends on what you want to do and your personal preferences. For example, JavaScript or PHP for web development, C or C++ for systems programming or anything requiring very high performance. I can't comment on Python since I haven't really used it myself, but I've heard it's good.

 

[abdude13]

I spent years learning Japanese just so I can understand twitter comics without hassle, and I'm not going to spend more years learning programming language. Thanks, programmers in this thread! Programming sounds intense as hell! I'm scared!

 

[bugcatcher06]

fucking dumbass

 

[hifumin]

oh well
he's fired

 

[gartender]

@Flare77

A normal delete script is just DELETE FROM tablename.

So if I'm understanding this correctly, you would first need to select something from the table, then that statement, DELETE FROM tablename, would delete that selection?

So say I have a table with one element, and I wanted to delete that element. Would the statements look like this:

SELECT element

DELETE FROM table

?

 

[ninjazz]

and nothing bad happened.

the end.

 

[ClueByFour]

@Mogima Go with C: real manly men* use a language whose creater's entire design philosophy towards memory management was "let's give the user total control; what's the worst that could happen?"

(If you do start learning C, be sure to ask someone experienced for pointers. It'll be worth it... for them.)

_{* Well, as manly as programmers get, at least.}

 

[BlazingMagpie]

Ah yes, we don't waste resources on development databases and test everything on production database.
Backups? We don't need them, our system is just that good.
Oh, and we also give unlimited access to database to our employees from day 1 so they can do more work.

 

[Flare77]

@gartender no no, what I meant is if you just want to delete items from a table, you don't need * (or a column identifier). You just

DELETE
FROM TableName.

You use * only during select because * is a shorthand for "all columns" and during delete queries, you don't delete columns, you delete entries.

 

[Catsuey]

h-he's working on a test database right 🤠

 

[KinGembuL]

Yeah it’s fine

BECAUSE IT IS WRONG QUERY

For table is drop, not delete

 

[AlmondMagnum]

@KinGembuL
He erased all the entries in that table. It's plenty bad. Especially if they don't have a backup.

Drop would erase the table itself. It's worse, but not much. Between a few seconds to a few minutes of work worse, unless they've done something really exotic. But losing the data could kill the company.

@gartender
No, it's Delete FROM tbl WHERE <criteria>.
Since he hasn't put a WHERE clause, he erased everything in that table.

 

[Dash018]

Explanation query :
To delete all rows from the customer table, you use the DELETE statement without the WHERE clause as follows:

DELETE FROM tbl_Customer ;
All rows in the tbl_Customer table deleted

Source : https://www.mysqltutorial.org/mysql-delete-statement.aspx/

 

[Nehona]

Frankly it's stupid and unbelieavable.
Any firm would have backups
Any firm would have checks in place, and strict permissions on who can operate on the database directly

... I understand drama, but this is just pointless

 

[Meijin]

This happened to one of my old employers but with the catalog of offerings. Said company was a thousand man strong and the disruption to services was noticeable for days. Funny thing was that while I worked there I kept a copy of that data under my schema to play around with and would have been a quick fix if I was still around when it happened. The looks on my ex-colleagues' faces at lunch when I told them that was priceless.

 

[gartender]

@Flare77

I'm more confused about how we select specific elements to delete from a table. I get that the * means everything in that table.

@AlmondMagnum answers my question:

No, it's Delete FROM tbl WHERE <criteria>.
Since he hasn't put a WHERE clause, he erased everything in that table.

So putting it all together deleting a certain element would look like

DELETE
FROM table
WHERE conditions

?

 

[MPnoir]

@gartender

I'm...probably going to buy that.

It's surprisingly good. I already knew everything because i had a database course in uni but it covers a lot of topics. I got the pdf for cheap once in a Humblebundle.

 

[wakka02]

D... Did he just wipe the entire customer database? Is this guy's mind made of jelly?

 

[vvasu001]

Just a full stack developer passing by who won't explain what was done here because it shouldn't even matter. HE FUCKED UP IN TERMS OF COMPUTER! THAT'S ALL THAT MATTERS

 

[Freestyle]

fucking moron