1.多行SQL如下 

SELECT
	T2.* 
FROM
	(
	SELECT
		@r AS _id,
		( SELECT @r := parent_id FROM topo_tree WHERE id = _id ) AS parent_id,
		@l := @l + 1 AS lvl 
	FROM
		( SELECT @r := 15, @l := 0 ) vars,
		topo_tree h 
	WHERE
		@r <> 0 
	) T1
	JOIN topo_tree T2 ON T1._id = T2.id 
ORDER BY
	T1.lvl DESC;

2.复制到记事本里,用notepad++打开

快速将多行SQL格式化成一行_mysql

 3.全部替换