Some times I‘m thinking that in reality there is only CRD and not CRUD, cause Create and Update are so similar …
What you think? I mean if I would make a new SQL Concept I would speak only of:
S R D
which would mean: Set, Read, Delete… thats it. No big difference between Create and Update… And of course in the Set statement I would define/inject that unique # parameter to identify the row… and you could then also add multiple Sets, or increment them…
In my mind if I had a gun to my head, and was instructed that i had to merge at least one of these from Create, Read, Update, Delete. I would say the best one to merge into one would be update and delete, as both require the same instruction, it needs to know which record or records to update, and the same for the delete, but how one would join Create, and Update, is just a scary thought in my mind.
I am an old man, please don’t give me heart attacks by taking any letter from my CRUD…
Actually Update could be replaced with Read old copy -> Delete old copy -> Create New copy so not as daft as it sounds I suppose but I don’t think it will catch on.
But what about “S”, CRUD is good but SCRUD is really the king of database world.