ChickenFarm/SERVER/ChickenFarmV3/.script/sql/init_seed.sql

INSERT INTO f_wing_tag (wing_tag_num, chicken_id, status, create_org, create_by,update_by, create_time)
SELECT
    CONCAT('', LPAD(seq, 6, '0')),
    NULL,
    0,
    100,
    1,
    1,
    NOW()
FROM (
         SELECT (a.a + b.a * 10 + c.a * 100 + d.a * 1000 + e.a * 10000 + f.a * 100000) AS seq
         FROM (
                  SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
                  UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
              ) AS a
                  CROSS JOIN (
             SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
             UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
         ) AS b
                  CROSS JOIN (
             SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
             UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
         ) AS c
                  CROSS JOIN (
             SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
             UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
         ) AS d
                  CROSS JOIN (
             SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
             UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
         ) AS e
                  CROSS JOIN (
             SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
             UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
         ) AS f
     ) AS sequence
WHERE seq <= 999999;