Re:Learn SQL, dammit
by chris_mahan on Wednesday May 08, 2013 @05:57PM
(#5677221)
Technically, an UPDATE is a DELETE and INSERT. so if you only knew SELECT, DELETE, and INSERT, you could do crud.
Re:Learn SQL, dammit
by prodigal_erik on Wednesday May 08, 2013 @06:13PM
(#5677307)
In practice, SQL access control is pretty simple-minded compared to relational algebra, and a server may not notice that your DELETE and INSERT are equivalent to an UPDATE which only modifies columns you're authorized to.
Re:Learn SQL, dammit
by dragonwriter on Wednesday May 08, 2013 @06:19PM
(#5677341)
I was referring to what you could practically survive with as an application developer who didn't control the databases involved; for the reasons prodigal_erik states in their reply, DELETE + INSERT, while you can do equivalent transformations to UPDATE with them, aren't going to be a general-purpose replacement for developers of real-world applications against real-world databases that they do not control.
Re:Learn SQL, dammit
by chris_mahan on Thursday May 09, 2013 @12:52AM
(#5678902)
I agree with you. I was just saying that it is possible to do crud with just three sql commands. Not friendly, I agree, but possible.
If you were a developer that did interact with databases (but not a DBA or specifically a "database developer"), you could probably get by with the four that correspond to CRUD operations directly (SELECT, INSERT, UPDATE, DELETE), so knowing "about 3" isn't all that bad.