随便找个ai 润色一下

CREATE TABLE xs (
    时间 DATETIME,
    商品名 VARCHAR(255),
    单价 DECIMAL(10, 2),
    规格 VARCHAR(100),
    数量 INT,
    金额 DECIMAL(10, 2)
);

DELIMITER //

CREATE PROCEDURE p1(start_time DATETIME, end_time DATETIME)
BEGIN
    DECLARE m INT;
    DECLARE i INT DEFAULT 1;
    DECLARE sj DATETIME;
    DECLARE xh INT;
    DECLARE sp VARCHAR(255);
    DECLARE jg DECIMAL(10, 2);
    DECLARE gg VARCHAR(100);
    DECLARE zsl INT;
    DECLARE sl INT;
    DECLARE zj DECIMAL(10, 2);

    SET m = FLOOR(RAND() * (30 - 10 + 1)) + 10;

    WHILE i <= m DO
        SET sj = DATE_ADD(start_time, INTERVAL FLOOR(RAND() * TIMESTAMPDIFF(MINUTE, start_time, end_time)) MINUTE);
        SET xh = FLOOR(RAND() * 45) + 1;

        SELECT 商品名, 价格, 规格, 数量 INTO sp, jg, gg, zsl
        FROM kc
        WHERE 序号 = xh;

        SET sl = FLOOR(RAND() * zsl) + 1;
        SET zj = jg * sl;

        INSERT INTO xs (时间, 商品名, 单价, 规格, 数量, 金额)
        VALUES (sj, sp, jg, gg, sl, zj);

        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

CALL p1('2024-6-1 6:0:0', '2024-6-1 21:0:0');

SELECT * FROM xs;