MySql 查询指定字段的数据累加到指定值停止并返回结果应该怎么写？

SELECT id,name,value,total_value FROM
(
    SELECT id,name,value,@total := @total + value AS 'total_value' FROM 
    (select id,name,value from google_uac_placement order by id asc) AS temp,
    (SELECT @total := 0) AS T1
    ORDER BY id ASC
) AS a
WHERE total_value <= 100;Copy

SELECT id, name, value, total_value
FROM (
    SELECT id, name, value
        , @total := @total + value AS "total_value"
    FROM (
        SELECT id, name, value
        FROM google_uac_placement
        ORDER BY id ASC
    ) temp, (
            SELECT @total := 0
        ) T1
    ORDER BY id ASC
) a
WHERE total_value - `value` < 100;Copy