【mysql中利用联合查询批量处理数据库】mysql中利用联合查询批量处理数据(更新,查询,统计)语句

【www.bbyears.com--mysql教程】

# 联合查询回复数

SELECT ask.id, count( answer.father_id ) , ask.answer_num
FROM `表名_ask` AS ask
LEFT JOIN `表名_answer` AS answer ON ask.id = answer.father_id
GROUP BY answer.father_id
ORDER BY ask.id ASC

# 修改城市ID

UPDATE 表名_ask SET cityid =
(
    SELECT cityid
    FROM 表名
    WHERE 表名_ask.borough_id = 表名.id
    ORDER BY id ASC LIMIT 0, 1
)

# 修改 回复数

UPDATE 表名_ask SET answer_num =
(
    SELECT count( 表名_answer.father_id )
 FROM `表名_answer`
 where 表名_ask.id = 表名_answer.father_id
 GROUP BY 表名_answer.father_id
 ORDER BY 表名_ask.id ASC
 LIMIT 0 , 1
)

最后

建义一下如果有可能我们还是把sql分开来处理这样会更好一些哦,本站原创文章转截必须注明来源http://www.111cn.net

本文来源：http://www.bbyears.com/shujuku/49979.html