What is the difference Between MySQL : Tables vs Views vs Routines(Store Procedures)?
I am familiar with tables. heard about views and routines . for both name itself says , it can allow to view data's is it?
In MySQL I am having these 3 under schemas... Does these 3 are available in other SQL too like POSTGRES?
What is the functional difference between these 3?
In a nutshell.
A table has physical storage of data.
A view is an sql query that can be queried like a table but does not have any physical storage as such.
A procedure is a programmable sub-routine that can perform any number of actions permissible to the database base and the executing user.
These definitions can vary depending on the db solution that you are using. I suggest reading the relevant documentation.