MySQL插入数据问题

insert into tb_app_login_info
(id,user_code, account, user_name, login_time, app_id, app_name, ip)
select (select uuid()),
(select a.ygdm from portal_platform_new.gy_ygxmm a order by rand() limit 1),
(select a.ygdm from portal_platform_new.gy_ygxmm a order by rand() limit 1),
(select a.ygxm from portal_platform_new.gy_ygxmm a order by rand() limit 1),
date_add(NOW(), interval rand() * -180 day) rand_date,
(select b.id from portal_platform_new.tb_app_info b order by rand() limit 1),
(select b.app_name from portal_platform_new.tb_app_info b order by rand() limit 1),
'172.18.0.6'
from tb_app_info a 
-- limit 10

---

问题：为什么是19条随机产生的记录，我改如何控制随机出来的条数，比如我想要100条。