Queries returning 0 even though data exists
Hello everyone,
I'm running workbench 6.3.10 and running MySQL 5.7.21. I'm having an issue where my queryies in workbench are returning a value of 0 but MySQL CLI returns with no issues. I wasn't having an issue before when my table was around 80k rows, now that my table has expanded to 230K it no longer will return anything in workbench.
I've used "SELECT * FROM table" and "SELECT * FROM table WHERE id = 1". Neither command working in workbench, but both work in CLI.
Subject
Views
Written By
Posted
Queries returning 0 even though data exists
728
May 29, 2018 08:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.