I’m new to programming. I’m starting with databases and management of data.

Will CRUD be applied to a data record – everytime ?

I’d appreciate if you please don’t post code as examples – I may not be able to make sense of it. Instead – consider telling me a simplified example from the real world. Thank you much in advance.

When I tell the database engine to go fetch me data – and I supply it a ‘IF’ or ‘WHERE’ condition – does the handling of this condition differ across different database engines like Oracle, Postgre, MySql etc. – when the engine hits the data record ? I’m referring to the time of contact – of the engine hitting the record.

If yes – what exact way does it differ? Is the sequence of CRUD changed ?

Can the engine figure out what I missed clearly specifying in the query ?

Looking forward to a wonderful conversation with lots of learning.

I tried queries with different engines and noticed the change in syntax. This led me to investigate further. I was expecting the engine design to be slightly different from each product – and that’s what led me to this question.