摘要:
根据子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 ( 阅读全文
摘要:
根据子id找到最终父id ,放开parent_id = '0' 看到所有父id WITH RECURSIVE dict AS ( SELECT * FROM category WHERE id= '6' union ALL SELECT category.* FROM category, dict 阅读全文
摘要:
一、强制类型转换 <script type="text/javascript"> //强制数据类型转换 //[1]转字符串 //数值转字符串 var a = 100; console.log(typeof a.toString()) ; //类型为String var b = NaN; b = b. 阅读全文