无法对数据库中的select数据使用限制

Question

我使用PHP MySQL select数据，没有错误。

$sql = "SELECT pd_id, pd_name, pd_price, pd_qty 
        FROM tbl_product ORDER BY pd_id DESC";

我只想选择6行。所以，我像这样编辑代码。

$sql = "SELECT pd_id, pd_name, pd_price, pd_qty 
        FROM tbl_product ORDER BY pd_id DESC LIMIT 6";

然后，它会显示这样的错误。

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 6' at line 2

如何从MySQL中选择数据6行

Answer 1

试试这个

$sql = "SELECT pd_id, pd_name, pd_price, pd_qty 
        FROM tbl_product ORDER BY pd_id DESC LIMIT 0, 6 ";

Answer 2

SELECT TYPE FROM stuff ORDER BY STUFF_ID DESC LIMIT 6

将您的查询替换为上面使用的列