generating lots of sample records
I want to generate a bunch (10000-100000) of sample records in a table
with IDs from N to N+K-1. which is equivalent to:
insert into `mytable`.`myfield` (id) values (2000),(2001),(2002),
(2003),(2004);
except instead of having to write out numbers manually, I want to
generate records automatically. Here N = 2000, K=5.
what's the easiest way to do this? (preferably in sql but if there is
another easy way, I'm open to hearing it)
|