UPDATE Statement TABLE  can also be used together in unions with  SELECT  statements,  VALUES  statements, or both. See Section 13.2.10.3, “UNION Clause” . 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): See Section 13.2.11, “Subqueries” , for more information. 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: Multiple-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 ] ... UPDATE [LOW_PRIORITY] [IGNORE]  table_references SET  assignment_list [WHERE  where_condition ] • 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. •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. •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: •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. | 6 | 7 | +---+----+ 6 rows in set (0.00 sec) SELECT * FROM t1 WHERE a IN (TABLE t2); SELECT * FROM t1 WHERE a IN (SELECT x FROM t2); SELECT * FROM t1 WHERE a IN (SELECT * FROM t2); 13.2.13 UPDATE Statement 2702