MySQL Forums
Forum List  »  Views

Re: Query not working when trying to create view
Posted by: Peter Brawley
Date: April 04, 2019 01:44PM

Without the Create Table scripts, we can't identify the syntax error. Apparently Workbench hides it? Terrific.

Run the Create View stmt in the mysql client program, note the error message. If you don't know how to fix the error, post the error message and Show Create Table results for all references tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query not working when trying to create view
318
April 04, 2019 01:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.