作者： admin

java-maven-lib-ref-onnxruntime

Posted on by admin

onnxruntime

<!-- https://mvnrepository.com/artifact/com.microsoft.onnxruntime/onnxruntime -->
<dependency>
    <groupId>com.microsoft.onnxruntime</groupId>
    <artifactId>onnxruntime</artifactId>
    <version>1.22.0</version>
</dependency>

 

SQL-生成时间日期和车牌

Posted on by admin
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;