Create UNIQUE view from multiple tables where some fields are ignored

0 votes
asked Mar 16, 2016 by narayanan (1,300 points)
I would like to create view like:CREATE OR REPLACE VIEW all_cities AS SELECT city,date_added FROM tableA UNION DISTINCT SELECT city,date_added FROM tableB UNION DISTINCT SELECT.

4 Answers

0 votes
answered Jun 2, 2016 by Simple (820 points)
Best answer
This is the official page
+2 votes
answered Apr 5, 2016 by molsan (310 points)
This thread gives some answers. I realize that present documentation CREATE TABLE Syntax - MySQL is only a preliminary document
commented Apr 7, 2016 by n2341 (600 points)
More details see this post
commented Apr 7, 2016 by summerfield7 (500 points)
Seems remarkable that this bug should have gone unfixed so long. It has good documentation
0 votes
answered Apr 24, 2016 by aquile (190 points)
I have not yet tried it myself, but you can find it at Designing INSTEAD OF Triggers -
And there is no single reason to use single quotes as much as possible
commented Apr 25, 2016 by Berger (150 points)
Minimized in that event
0 votes
answered May 7, 2016 by nivar181 (180 points)
I think that the best would be Creating Indexes - Oracle
It would only have been a separating edge if that had not been the case

Related questions

0 votes
4 answers
+1 vote
4 answers
0 votes
3 answers

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!