support for LIMIT [offset,] lines
Exemple:
SELECT * FROM categories INNER JOIN products ON categories.id_cat = products.id_cat LIMIT 0,10
SELECT * FROM categories INNER JOIN products ON categories.id_cat = products.id_cat, LIMIT 0, 10
also reported in forum
SELECT ... ORDER BY ... DESC LIMIT ...
Log in to post a comment.
Exemple:
SELECT
*
FROM
categories
INNER JOIN products
ON categories.id_cat = products.id_cat
LIMIT 0,10
And Designer transform it to:
SELECT
*
FROM
categories
INNER JOIN products
ON categories.id_cat = products.id_cat,
LIMIT 0,
10
also reported in forum
SELECT ...
ORDER BY ... DESC
LIMIT ...
Last edit: PAscal 2016-03-20