Tolong, saya nak cari jalan lain
Contoh data
| Tarikh | tomato | Telefon | Tempah | Pen |
|---|---|---|---|---|
| 2022-05-15 | 2 | 2 | 3 | 1 |
| 2022-05-15 | 3 | 3 | 3 | 2 |
Saya dah nampak result ni
| Tarikh | tomato | Telefon | Tempah | Pen |
|---|---|---|---|---|
| 2022-05-15 | 5 | 5 | 6 | 3 |
Saya guna ini
insert into sales.copy
select date,
sum(tomato),
sum(phone),
sum(book),
sum(pen)
from copy
where date = '2022-05-15';
delete from sales.copy
where date = '2022-05-15'
LIMIT 2;
Tetapi saya mahu cara lain untuk menerangkan bahagian ini secara ringkas
'date, sum(tomato), sum(phone)...'
![[Web front-end] Permulaan pantas Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Jadi kumpulkan sahaja hasilnya
select date, sum(tomato), sum(phone), sum(book), sum(pen) from copy where date = '2022-05-15' GROUP BY date