How to fill a table with test data: from hand-written INSERTs to generating rows with SQL
The ways I filled tables to test an application, from the most naive to the one I use today: INSERTs by hand, the table that copies itself, a series generated with SQL and a procedure that reads the columns. With the code for each database engine and the version where it starts to work.
Test dataDevelopmentMySQLMariaDBPostgreSQLSQLiteSQL ServerOracleClickHouse