CODEWITHSUNDEEP
mysqlview
This_Is_Fun
This_Is_Fun

Reputation: 183

MySQL DB views: Do both tables need to have the same name?

I know how to use a view of *example_table* in *example_table* in a second DB. Can a view of *example_table* be used in *different_example_table*?

Do both tables need to have the same name?

Upvotes: 0

Views: 37

Answers (1)

zerkms
zerkms

Reputation: 254944

VIEW is just a special kind of object that holds a query.

So you can give it any syntactically correct name you want

Upvotes: 1

Related Questions