View Single Post

  #1 (permalink)  
Old 04-27-2007
Jason S
 
Posts: n/a
Default 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)

Reply With Quote