节点MySQL连接结果集有问题

Question

使用MySQL连接节点(使用mysql2/promise)

const sql = `
SELECT *
FROM Applicant
WHERE ApplicationId = ?
`;
const result = await this.mysqlManager.Query(sql,number);
console.log(result);

public async Query(sql: any, parameters?: any, connection?: PoolConnection): Promise<any>
{
const con = connection || (await this.GetConnection());
try
{
const data = await con.query(sql, parameters);
return data;
}
catch (error)
{
con.release();
throw error;
}
}

但得到回应

ColumnDefinition {_buf:<缓冲区3a _x0030_0=" _x0031_6=" _x0030_3=" _x0036_4=" _x0036_5=" _x0036_6=" _x0030_8=" _x0037_0=" _x0037_2=" _x0036_f=" _x0036_c=" _x0030_9=" _x0034_1=" _x0036_9=" _x0036_3=" _x0036_1=" _x0036_e=" _x0037_4=" _x0030_5=" _x0035_0=" _x0034_369=" _x0037_9=" _x0034_3=" _x0030_c2376个字节=">_clientEncoding:"use utf8",_catalogLength: 3,_catalogStart: 2329,_schemaLength: 8_schemaStart: 2333,_tableLength: 9,_tableStart: 2342,_orgTableLength: 9,_orgTableStart: 2352,_orgNameLength: 16,_orgNameStart: 2379,characterSet: 224,编码:"use utf8",名称:"SalaryDayRangeTo",columnLength: 80,columnType: 253,国旗:0,小数:0}

谁能帮我解决这个问题吗?

Answer 1

const data = await const .query(sql, parameters);返回数据[0];

由于第一个元素由数据和其他属性组成模式信息。