MySQL Forums
Forum List  »  MySQL Workbench

Queries returning 0 even though data exists
Posted by: christopher ottersberg
Date: May 29, 2018 08:09AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Queries returning 0 even though data exists
117
May 29, 2018 08:09AM


Sorry, only registered users may post in this forum.

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.