MySQL连表操作_MySQL

1、自连接

    select * from product where vender_id = (select verder_id from product where name='Dove')

    select p1.* from product p1, product p2 where p1.id = p2.id and p2.name = 'Dove'

 

2、根据同表字段更新

    update product p1,product p2  set p1.photo_status = 2

    where p1.id = p2.id and p2.photo_status is null

 

3、连接要有条件，否则将出现笛卡尔积