INSERT INTO cb_shebei_neicun (guige, daxiao)
SELECT '金士顿', '32G' 
FROM information_schema.tables 
LIMIT 100;

mysql8.0下面语句

INSERT INTO cb_shebei_cpu (xinghao, danwei)
SELECT 'AMD 7742', '颗'
FROM (
    SELECT ROW_NUMBER() OVER () AS id
    FROM information_schema.columns
    LIMIT 510
) AS numbers;