SQLeo Visual Query Builder / Discussion / Technical questions: query builder: LIMIT syntax

Comment has been marked as spam.
Undo

View and moderate all "Technical questions" comments posted by this user

Mark all as spam, and block user from posting to "Discussion"

Anonymous - 2016-03-20

Look this query:

SELECT
traducciones.Id,
traducciones.En,
traducciones.Es,
traducciones.Fecha_Actualizacion
FROM
traducciones
ORDER BY
traducciones.Id DESC
limit 5

If you paste this query in the syntax tab and run it, it's fine, but if you change to designer tab, you need refresh, if you click in the button: yes, the syntax changed to:

SELECT
traducciones.Id,
traducciones.En,
traducciones.Es,
traducciones.Fecha_Actualizacion
FROM
traducciones
ORDER BY
traducciones.Id limit5 DESC

We lost the limit option, and it's in order by option.
Can you help me?

Thanks

Look this query: SELECT traducciones.Id, traducciones.En, traducciones.Es, traducciones.Fecha_Actualizacion FROM traducciones ORDER BY traducciones.Id DESC limit 5 If you paste this query in the syntax tab and run it, it's fine, but if you change to designer tab, you need refresh, if you click in the button: yes, the syntax changed to: SELECT traducciones.Id, traducciones.En, traducciones.Es, traducciones.Fecha_Actualizacion FROM traducciones ORDER BY traducciones.Id **limit5** DESC We lost the limit option, and it's in order by option. Can you help me? Thanks

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2016-03-20

It's an "old" bug
We have it in our todo list ...

Note: SQLeo doen't need the LIMIT keyword as results are displayed page per page.
Regards

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.
- Comment has been marked as spam.
  Undo
  
  View and moderate all "Technical questions" comments posted by this user
  
  Mark all as spam, and block user from posting to "Discussion"
  
  Anonymous - 2016-03-20
  
  I need this keyword in my querys what can I do?
  
  I need this keyword in my querys what can I do?
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.
  
  New Attachment:
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Anonymous
    
    Add attachments
    Cancel
    You seem to have CSS turned off. Please don't fill out this field.
    
    You seem to have CSS turned off. Please don't fill out this field.

query builder: LIMIT syntax

Helping users to quickly understand SQL queries

Forums

Help

query builder: LIMIT syntax

query builder: LIMIT syntax

Helping users to quickly understand SQL queries

Forums

Help

query builder: LIMIT syntax document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

query builder: LIMIT syntax