troubleshooting Question

Mysql Temporary Views - NAME COLLISION

Avatar of kingjely
kingjelyFlag for Australia asked on
DatabasesMySQL ServerSQL
9 Comments3 Solutions538 ViewsLast Modified:
I have a VIEW called TABLE_1

It's always called TABLE_1 because my command is

CREATE VIEW TABLE_1 AS,

What if 2 people want to run this VIEW at the SAME time
The first one works, the second one fails because the VIEW NAME already EXISTS

Is there a command to give a VIEW a temporary VIEW NAME everytime it is RUN?

Thankyou.


ASKER CERTIFIED SOLUTION
flytox06

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros