Generating fibonacci sequence in MySQL

fibonacci.mysql

WITH 
    RECURSIVE fib(n, a, b) AS
        (
            SELECT 1, 1, 0
            UNION ALL
            SELECT n + 1, a + b, a
            FROM fib
            WHERE n < 10
        )
    SELECT a
    FROM fib;