zxcvb12zxcvb12的博客

SELECT * FROM (SELECT product_id, product_name,product_code,product_price,product_versionFROM product_2ORDER BY product_version DESC LIMIT 1000000) pGROUP BY product_id LIMIT 5,8;SELECT * FROM product_2 WHERE (product_id,product_version) IN ( .

SELECT T2.id, T2.name FROM ( SELECT @r AS _id, ( SELECT @r := parent_id FROM table1 WHERE id = _id ) AS parent_id, @l := @l + 1 AS lvl FROM ( SELECT @r := '149f3767-6c76-483e-bea6-9c2d...