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...
Using eBay as an example, explain how you can verify you are using the secure eBay Web page.
What will be an ideal response?
What does the PHP construct exit return?
a. 0 b. true c. nothing d. 1
The following statement should print the integer value of 'c'. cout << 'c';
What will be an ideal response?
________ is a subset of the Internet that hosts and distributes topic-based discussion forums
A) A dial-up computer network B) A BBS C) A discussion forum D) Usenet