MySQL DELETE 与 SELECT(?)

Question

我有 2 个表，我有点困惑......

      |products|                          
________________________
|  id  | products_name |
|______________________|
|   1  |  iphone4      |
|   2  |  htc desire   |
    etc.............


     |special_price|
________________________
|  id  | products_price|
|______________________|
|   1  |  400          |
|   2  |  500          |
    etc.............

我想做的是:

DELETE (ALL) FROM special_price WHERE products_name='iphone4'

这怎么会发生？

Answer 1

您需要找到该 product_name 的 ID，试试这个:

with IN:(对复杂条件有用)

DELETE FROM special_price 
WHERE id IN ( SELECT id FROM products WHERE products_name = 'iphone4' )