mysql实现99乘法表

以下是使用MySQL实现99乘法表的两种方法：

1.使用SELECT语句实现：

SELECT CONCAT_WS(' ', a.num, 'x', b.num, '=', a.num*b.num) AS result
FROM
(SELECT 1 AS num UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS a
CROSS JOIN
(SELECT 1 AS num UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS b
WHERE a.num >= b.num;

2.使用CREATE PROCEDURE语句创建存储过程实现：

CREATE PROCEDURE multiplication_table()
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE j INT DEFAULT 1;
    DECLARE result VARCHAR(50);
    WHILE i <= 9 DO
        WHILE j <= i DO
            SET result = CONCAT_WS(' ', j, 'x', i, '=', i*j);
            SELECT result;
            SET j = j + 1;
        END WHILE;
        SET j = 1;
        SET i = i + 1;
    END WHILE;
END;

然后执行以下语句调用存储过程：

CALL multiplication_table();