There are three set operations: union, intersection, difference. Define each of these operations. Which one(s) does MySQL support?
What will be an ideal response?
The union of two tables creates a temporary table containing every row that is in either the first table, the second table, or both tables. The intersection of two tables creates a temporary table containing all rows that are in both tables. the difference of two tables creates a temporary table containing the set of all rows that are in the first table but that are not in the second table. MySQL only supports the UNION operator.
You might also like to view...
Which of the following will load the applet, TestApplet?
A)
B)
C)
It is best when you are picking up a heavy laser printer to bend at your knees and use your legs to lift
Indicate whether the statement is true or false
To draw a square instead of a rectangle, a circle instead of an oval, or an equilateral triangle instead of an isosceles triangle, press and hold the Tab key while you drag to draw the shape.
Answer the following statement true (T) or false (F)
The first generation of packet-switching technology was called:
A. X.25 B. ATM C. SONET D. OC-1