如何从MySQL获取RowDataPacket对象并提取COUNT(*)统计值？

Hey there! Let's work through this issue together. The problem you're hitting is all about how you're accessing the property in the RowDataPacket object returned by your MySQL query.

Why console.log(data[0].COUNT) returns undefined #

When you run SELECT COUNT(*) FROM articles_table, the resulting object’s property name is exactly the string 'COUNT(*)' — not COUNT. Since this property name includes special characters (*), you can’t access it using standard dot notation (like .COUNT), which only works for valid JavaScript identifiers (letters, numbers, underscores, and no leading numbers).

Solution 1: Access the property using bracket notation #

You can directly reference the full property name as a string inside square brackets to get the value:

console.log(data[0]['COUNT(*)']); // This will output 13

Solution 2: Use an alias for your count (recommended) #

A cleaner, more readable approach is to give your COUNT(*) an alias in the SQL query. This simplifies the property name you need to reference in JavaScript:

SELECT COUNT(*) AS total_articles FROM articles_table

Now you can access the value with either dot notation or bracket notation:

console.log(data[0].total_articles); // Outputs 13
// Or
console.log(data[0]['total_articles']); // Also works

Using an alias is the better long-term choice because it makes your code easier to understand and avoids dealing with special characters in property names.

内容的提问来源于stack exchange，提问作者Sylvia