MySQL Views

[The Little Guy]

Just today I head about MySQL views, I looked into them, but I am not really sure why you would use them. What would be the point of a view, in what type of situation would I want to use one, and what other info can you tell me?

[waynewex]

You can create a View very easily:

 

CREATE VIEW viewname AS

SELECT * FROM tablename;

 

Views can then be used like tables.

 

So...

 

SELECT * FROM viewname;

 

They're mostly used to cordon off what pieces of data certain users can see. For example, a department manager might get to see a view that has employee names and addresses, whereas a HR manager might get to see a view that has the name, address and salary.