要查出pl和 program2个表中最近100个更新的记录!!偶原来不知道怎么弄呢!经人点拨后,写了以下语句,经证明是正确的
(
SELECT
'node'
,
uid
,
MODIFY AS m
FROM pl
MODIFY AS m
FROM pl
)
UNION (
UNION (
SELECT 'pl' , uid ,
CHANGED AS m
FROM program
)
ORDER BY m
LIMIT 0 , 50
ORDER BY m
LIMIT 0 , 50