Easily add test data via a procedure loop. :)

addTestData.sql

DROP PROCEDURE IF EXISTS addTestData;

delimiter //

CREATE PROCEDURE addTestData(cnt INT)
BEGIN
	SET @x = 0;
	REPEAT
		SET @x = @x + 1;
		INSERT INTO `TABLE_NAME_HERE` (`name`) VALUES ( CONCAT( 'test_data_', @x) );
	UNTIL @x >= cnt END REPEAT;
END

//

call addTestData(100);