| 13 | 3 | | 9 | 5 | +----+----+ 3 rows in set (0.00 sec) 

TABLE  differs from SELECT  in two key respects: 

• TABLE  always displays all columns of the table. 

• TABLE  does not allow for any arbitrary filtering of rows; that is, TABLE  does not support any WHERE clause. 

For limiting which table columns are returned, filtering rows beyond what can be accomplished using ORDER BY  and LIMIT , or both, use SELECT . 

TABLE  can be used with temporary tables. 

TABLE  can also be used in place of SELECT  in a number of other constructs, including those listed here: 

•With UNION , as shown here: 

mysql> TABLE t1; +---+----+ | a | b | +---+----+ | 2 | 10 | | 5 | 3 | | 7 | 8 | +---+----+ 3 rows in set (0.00 sec) mysql> TABLE t2; +---+---+ | a | b | +---+---+ | 1 | 2 | | 3 | 4 | | 6 | 7 | +---+---+ 3 rows in set (0.00 sec) mysql> TABLE t1 UNION TABLE t2; +---+----+ | a | b | +---+----+ | 2 | 10 | | 5 | 3 | | 7 | 8 | | 1 | 2 | | 3 | 4 | | 6 | 7 | +---+----+ 6 rows in set (0.00 sec) 

The UNION  just shown is equivalent to the following statement: 

mysql> SELECT * FROM t1 UNION SELECT * FROM t2; +---+----+ | a | b | +---+----+ | 2 | 10 | | 5 | 3 | | 7 | 8 | | 1 | 2 | | 3 | 4 | 

