我使用 Express、Cors 和 Node 將本地 mysql 數(shù)據(jù)庫的 API 放在一起,現(xiàn)在正在嘗試提取數(shù)據(jù)。我有一個查詢,其中我構(gòu)建了一個 const 來提取一系列統(tǒng)計數(shù)據(jù),但我不知道如何最好地提取數(shù)據(jù),以便 json 中的每個元素都具有正確的字段:const express = require('express');const cors = require('cors');const mysql = require('mysql');const app = express();const COUNTS_QUERY = 'SELECT COUNT(*) AS total_stands FROM carts UNION SELECT SUM(current_orders) as total_orders FROM carts UNION SELECT AVG(rating) as rating FROM carts';app.listen(4000, () => { console.log('Server listening on port 4000')});//call query to count trucksapp.get('/stats', (req, res) => { connection.query(COUNTS_QUERY, (err, results) => { if(err) { return res.send(err) } else { console.log(results) return res.json({ data: results }) } })})我收到以下結(jié)果:{"data":[{"total_stands":1541},{"total_stands":35218},{"total_stands":2.9792}]}如何取回每個統(tǒng)計數(shù)據(jù)都有適當字段名稱的對象?
如何在對 API 的 Javascript 調(diào)用中返回 SQL 字段名稱?
拉風的咖菲貓
2021-10-21 16:07:02