| 6 | 7 | +---+----+ 6 rows in set (0.00 sec) 

TABLE  can also be used together in unions with SELECT  statements, VALUES  statements, or both. See Section 13.2.10.3, “UNION Clause” . 

•With INTO  to populate user variables, and with INTO OUTFILE  or INTO DUMPFILE  to write table data to a file. See Section 13.2.10.1, “SELECT ... INTO Statement” , for more specific information and examples. 

•In many cases where you can employ subqueries. Given any table t1  with a column named a , and a second table t2  having a single column, statements such as the following are possible: 

SELECT * FROM t1 WHERE a IN (TABLE t2); 

Assuming that the single column of table ts  is named x , the preceding is equivalent to each of the statements shown here (and produces exactly the same result in either case): 

SELECT * FROM t1 WHERE a IN (SELECT x FROM t2); 

SELECT * FROM t1 WHERE a IN (SELECT * FROM t2); 

See Section 13.2.11, “Subqueries” , for more information. 

•With INSERT  and REPLACE  statements, where you would otherwise use SELECT * . See Section 13.2.6.1, “INSERT ... SELECT Statement” , for more information and examples. 

• TABLE  can also be used in many cases in place of the SELECT  in CREATE TABLE ... SELECT or CREATE VIEW ... SELECT . See the descriptions of these statements for more information and examples. 

## 13.2.13 UPDATE Statement 

UPDATE  is a DML statement that modifies rows in a table. 

An UPDATE  statement can start with a WITH  clause to define common table expressions accessible within the UPDATE . See Section 13.2.15, “WITH (Common Table Expressions)” . 

Single-table syntax: 

UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition ] [ORDER BY ...] [LIMIT row_count ] value : { expr  | DEFAULT} assignment : col_name  = value assignment_list : assignment  [, assignment ] ... 

Multiple-table syntax: 

UPDATE [LOW_PRIORITY] [IGNORE] table_references SET assignment_list [WHERE where_condition ] 

