![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
hello world**
shdkahdklasdlajsdkld
展开
-
SQL GROUP BY
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 ( .原创 2021-01-06 17:01:49 · 1667 阅读 · 0 评论 -
mysql 根据id 查询父类ID,递归
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...原创 2019-07-03 11:45:43 · 1681 阅读 · 0 评论