jeudi 12 octobre 2017

`OFFSET` is not working mysql, phpmyadmin

OFFSET is not working

SELECT
  iContentID,
  vTitle,
  vContectNo
FROM
  `tbl_contact_list`
WHERE
  `eStatus` = Active AND `eDeleted` = 0
ORDER BY
  `vTitle` ASC OFFSET 0

Getting below error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

near 'offset 0' at line 1

phpmyadmin Version information: 4.0.10deb1
database Server version: 5.5.54-0ubuntu0.14.04.1 - (Ubuntu)
PHP version 7



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire