SQL-生成时间日期和车牌

WITH RECURSIVE index_loop AS (
    SELECT 1 AS idx  -- 起始索引（可改为0）
    UNION ALL
    SELECT idx + 1   -- 索引自增
    FROM index_loop
    WHERE idx < 100   -- 循环次数（此处为10次）
)
SELECT idx ,
FROM_UNIXTIME(
    FLOOR(
      UNIX_TIMESTAMP('2023-01-01 00:00:00') + 
      RAND() * (
        UNIX_TIMESTAMP('2023-12-31 23:59:59') - 
        UNIX_TIMESTAMP('2023-01-01 00:00:00')
      )
    )
  ) AS random_datetime,
CONCAT(
    ELT(FLOOR(1 + RAND() * 34), '京','津','冀','晋','蒙','辽','吉','黑','沪','苏','浙','皖','闽','赣','鲁','豫','鄂','湘','粤','桂','琼','渝','川','贵','云','藏','陕','甘','青','宁','新','港','澳','台'),
    ELT(FLOOR(1 + RAND() * 24), 'A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
    
    CONCAT(
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z')
    )
) AS license_plate
FROM index_loop;