Is there a way to automatically add all empty rows in MySQL with AUTO_INCREMENT up to some maximum value?

Question

MySQL

There is a table with default values ​​set. I just need to create a million autoincrement rows. Is there some simple way to do this? In fact, just create a million empty lines

Answer 1

create a million empty strings

WITH RECURSIVE 
cte AS ( SELECT 1 n
         UNION ALL
         SELECT n + 1  FROM cte WHERE n < 1000 )
INSERT INTO tablename (id)
SELECT NULL FROM cte t1 CROSS JOIN cte t2;