Forum Academy Marketplace Showcase Pricing Features

mySQL SQL query with LIMIT 10 generates popup error when initializing query

I cannot initialise a basic select with a LIMIT 10. Error pop up ‘Please limit the query to at most 200 entries’.

Is there something I am missing: My query working in MySQL Workbench and brings back the 10 rows but the front end doesn’t seem to recognise the LIMIT clause.

Can you share the query you’re running?

select column_name
from table_name
LIMIT 10;

where column name is a actual column and table_name is the actual table name.

I get the same issue, just didn’t realise it before! On my own database MySQL version 5.5.52-0+deb8u1

The limit works when I connect to the “employees” database in @georgeciobanu 's example on MySQL version 5.6.28-0ubuntu0.15.10.1 …

select * from employees limit 2

EDIT: spoke too soon, the limit is working on both databases … my other test had an additional filter.

select *
from fabrics
limit 10;

This is still generating a “Please limit to at least 200 records” pop up message. Please help.
I am able to access my database which is hosted on AWS via MySQL Workbench locally on my machine so there is no connection issues. The SQL I have wrote is valid and produces the correct results as per the LIMIT applied.

Does it work without the semicolon?

Hi,

No, tried with and without :frowning:

I just tried with newlines like yours, and got the same error message.
Try it all on one line:
select * from fabrics limit 10

1 Like

You are a star! that worked, I can move forward :slight_smile:
Thank you for taking the time to reply.

1 Like