mysqlselect优化数据update select
请教下各位大神，mysq update数据优化
遇到的问题是这样的。
表a有2个字段，ready_count,download_count
表b是统计表，有type,id
两个表的储存引擎都是MYISAM
需要把表b的数据count(1) group by(type)之后update到表a的那两个字段中。
我现在的SQL是这样的：
update a _t1
set
_t1.ready_count = (
SELECT count(1) FROM b _t2 WHERE _t2.tid = _t1.id and _t2.type = 1
),
_t1.download_count = (
SELECT count(1) FROM b _t2 WHERE _t2.tid = _t1.id and _t2.type = 2
),
The difference between drop and delete
What are the data types?
Why is my phone not turned off but when someone calls me it prompts me to turn it off?
How to become a close friend on TikTok
How to use findbugs
what python can do
What is the difference between guid and mbr formats
How to trigger keypress event
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
