MySQL returning different result when querying different columns

Question

SQL statement 1

const [rows, fields] = await pool.query("SELECT * FROM accounts WHERE username = ?", username);
console.log(rows);
return rows

SQL statement 2

const [rows, fields] = await pool.query("SELECT * FROM accounts WHERE id = ?", id);
console.log(rows)
return rows

It is the same database but the result I am getting back is displayed differently.

For the query for username,

[
  TextRow {
    id: 8,
    username: 'testing',
    password: '-',
    aws_id: '-',
    timestamp: 2020-02-23T23:38:06.000Z
  }
]

For the query by id

{
  '0': TextRow {
    id: 8,
    username: 'testing',
    password: '-',
    aws_id: '-',
    timestamp: 2020-02-23T23:38:06.000Z
  }
}

Why is it that when I am querying with ID, there is a "0" key appended to it.

c8999c 3f964f64 · Accepted Answer · 2020-03-04 10:43:58Z

2

Its possible that because id is unique, the results will never be a list of items, and "whatever you're using to connect to mysql" automatically formats for that.

some browsers also routinely add indexes to json that arent actually in the data. make sure you're not following a false-positive here and use "raw data" to view it

answered Mar 4, 2020 at 10:43

c8999c 3f964f64

1,6491 gold badge18 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Exceptions Over a year ago

I’m printing out the result from console.log. Not sure if it will make a difference.

c8999c 3f964f64 Over a year ago

me neither. the result isn't even (valid) JSON, its just something to keep in mind - the print of a data structure isnt necessarily exactly as it exists in memory. Can you provide info on your db connector for further analysis?

Collectives™ on Stack Overflow

MySQL returning different result when querying different columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related