CODEWITHSUNDEEP
mysqlnode.jsknex.js
Intoxicated Penguin
Intoxicated Penguin

Reputation: 364

Knex SQL Query Returning Nothing, MySQL Workbench Returns Proper Data

Trying to simply get a list of discordid's from my twitch_webhook table. This query comes out as SELECT * FROM twitch_webhook. In MySQL Workbench this query gives me the data I want, but in Knex/nodejs when I make the exact same query it returns []. Querying other tables in the same DB works as intended: its just this one. I have confirmed that the query that knex sends to my db is the exact same (except twitch_webhook is in 's). Any idea on what could be causing this would be great, or perhaps other ways of troubleshooting.

let twitch = await connection('twitch_webhook').select('*').catch(console.error).then(console.log);

Upvotes: 1

Views: 469

Answers (1)

Intoxicated Penguin
Intoxicated Penguin

Reputation: 364

The problem is the underscore in the table name: twitch_webhook. Something about character encoding. Removing the underscore from the name fixed the issue.

Upvotes: 1

Related Questions