两表连接修改 update t1,t2 set t2.address_detail='测试' where t2.user_id=t1.user_id and t1.open_id='12'; 有t1表的参数可修改t2的字段值 两表连接删除 delete t1 from t2 ,t1 where t1.user_id = t2.user_id; 执行即可删除两张或多张相关联的表 当然这里需要两张表存在主外键关系