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

Written By
Queries returning 0 even though data exists
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.