Partition Selection table, before all other options, including any table alias.) For example, the following query gets the name, employee ID, department, and city of all employees who work in the Sales or Delivery department (partition p1  of the  departments  table) at the stores in either of the cities of Nambucca and Bellingen (partition  p0 of the  stores  table): For general information about joins in MySQL, see Section 13.2.10.2, “JOIN Clause” . When the  PARTITION  option is used with  DELETE  statements, only those partitions (and subpartitions, if any) listed with the option are checked for rows to be deleted. Any other partitions are ignored, as shown here: Only the two rows in partitions  p0  and  p1  matching the  WHERE  condition were deleted. As you can see from the result when the  SELECT  is run a second time, there remains a row in the table matching the WHERE  condition, but residing in a different partition ( p2 ). UPDATE  statements using explicit partition selection behave in the same way; only rows in the partitions referenced by the  PARTITION  option are considered when determining the rows to be updated, as can be seen by executing the following statements: 4712 mysql>  UPDATE employees PARTITION (p0)  -> SET store_id = 2 WHERE fname = ’Jill’; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql>  SELECT * FROM employees WHERE fname LIKE ’j%’; mysql>  DELETE FROM employees PARTITION (p0, p1) -> WHERE fname LIKE ’j%’; Query OK, 2 rows affected (0.09 sec) mysql>  SELECT * FROM employees WHERE fname LIKE ’j%’; 3 rows in set (0.00 sec) 1 row in set (0.00 sec) +----+-------+--------+----------+---------------+ | id | fname | lname | store_id | department_id | +----+-------+--------+----------+---------------+ | 4 | Jim | Smith | 2 | 4 | | 8 | June | Wilson | 3 | 1 | | 11 | Jill | Stone | 1 | 4 | +----+-------+--------+----------+---------------+ +----+-------+-------+----------+---------------+ | id | fname | lname | store_id | department_id | +----+-------+-------+----------+---------------+ | 11 | Jill | Stone | 1 | 4 | +----+-------+-------+----------+---------------+ +-------------+---------------+-----------+------------+ | Employee ID | Name | City | department | +-------------+---------------+-----------+------------+ | 14 | Fred Goldberg | Bellingen | Delivery | | 5 | Mary Jones | Nambucca | Sales | | 17 | Mark Morgan | Bellingen | Delivery | | 9 | Andy Smith | Nambucca | Delivery | | 8 | June Wilson | Bellingen | Sales | +-------------+---------------+-----------+------------+ mysql>  SELECT -> e.id AS ’Employee ID’, CONCAT(e.fname, ’ ’, e.lname) AS Name, -> s.city AS City, d.name AS department ->  FROM employees AS e -> JOIN stores PARTITION (p1) AS s ON e.store_id=s.id -> JOIN departments PARTITION (p0) AS d ON e.department_id=d.id ->  ORDER BY e.lname; 5 rows in set (0.00 sec)