MySQL View scope

[Barguast]

What is the scope of a MySQL VIEW? For example, if I have two users simulataneously create a view with the same name but different SELECT criteria, and the first view is overwritten then I am going to run into problems.

If this is the case, is there are way to make views creatable on a per-user (per-connection) basis?

[laserlight]

You could read the MySQL reference on CREATE VIEW Syntax.

I would think that views should be treated as seriously as tables, and just as it is not likely to have such a conflict in table names since the schema would be worked out in advance, it should not be likely to have such a conflict unless the replacement of the view was intended.