Updating views in mysql


Makes me wonder if these people have ever worked with modern databases.

Stored procedures are one of the oldest methods of encapsulating database logic, but they are not the only method available.

Many relational databases nowadays have views, constraints, referential integrity with cascading update, delete, stored functions, triggers and the like.

updating views in mysql-11

Stored procedures are one of numerous mechanisms of encapsulating database logic in the database.

They are similar to regular programming language procedures in that they take arguments, do something, and sometimes return results and sometimes even change the values of the arguments they take when arguments are declared as output parameters.

The main beauty of a view is that it can be used like a table in most situations, but unlike a table, it can encapsulate very complex calculations and commonly used joins.

It can also use pretty much any object in the db except for stored procedures.

Total 3 (delta 2), reused 0 (delta 0) remote: Updating branch 'master'. remote: Preparing deployment for commit id 'a5e076db9c'.