sql Server 的語句WITH taball
AS ( SELECT ID ,
PID ,
DirName,
Levels ,
DirDesc
FROM dbo.S_AttachDir
WHERE ID = '{ID}'
UNION ALL
SELECT a.ID ,
a.PID ,
a.DirName ,
a.Levels ,
a.DirDesc
FROM taball
INNER JOIN dbo.S_AttachDir a ON taball.PID = a.ID
)
SELECT *
FROM taball；
求大神解答，怎么用mysql語句實現(xiàn)
Sql Server 數(shù)據(jù)庫 with AS 語句轉(zhuǎn)mysql，請幫助謝謝
收到一只叮咚
2018-08-01 05:11:03
